Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas? I call this the Excel Dialog Box Muddle! For years and years now these two dialogs change to Point mode by default the moment you start editing in the ‘Refers to’ […]
Excel Dialog Box Muddle Read More »
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 »