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 »
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 »
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 »
