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 »
Update 12/12/2021 Since writing this post in 2017, 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 Office 365 (although not in earlier stand alone
No more gaps – a formula to remove spaces in lists or empty rows in ranges Read More »
Update 12/12/2021 Since writing this post in 2017 about using a method to create a dependent dropdown using INDEX, 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() +
Dependent Dropdown using INDEX Read More »