Structured References

Validation Dropdown lists based on Table Columns ranges

Update 12/12/2021 Since writing this post in 2017 Validation Dropdown lists based on Table Columns ranges, Excel now has new revolutionary dynamic array formulas that really has overtaken all the workarounds for better dropdown lists we used to do such as described in my post below.  Now the new formula SORT() + UNIQUE() in Excel …

Validation Dropdown lists based on Table Columns ranges Read More »