Tag: dynamic formulas

Here is a quick but really useful coffee break 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 …

Dynamic sum formula for summing between two dynamic columns Read More »

Tagged with: ,

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown …

Autocomplete Workaround for Validation Dropdowns Read More »

Tagged with: , , , , ,

Up until quite recent versions of Excel (I am guessing a little here because I only have Office 365 so always have the latest and forget when I discovered this), if you wanted a dynamic list for your Validation Dropdowns, …

Validation Dropdown lists based on Table Columns ranges Read More »

Tagged with: , , ,