Here is a quick but really useful coffee break dynamic sum formula tip. I used this handy INDEX + MATCH based formula the other day and thought it was a good one to share… Say you have this typical accounting situation where you want to give the user the flexibility to choose the 2 ‘From’ …
Dynamic sum formula for summing between two dynamic columns Read More »
As might know there is no autocomplete functionality or any other features such as different font sizes with good old Data Validation cell dropdowns. On a client’s project I worked on today we really needed autocomplete capability. The dropdown list was 80 rows long and the values were messy to scroll through some with 3 …
Autocomplete Workaround for Validation Dropdowns 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 …
Validation Dropdown lists based on Table Columns ranges Read More »