Well it’s the Boxing Day holiday here in Aussieland 2017 and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day. Fantastic stuff. But also, this is the time of the year to think of New Year’s Resolutions. If you are not using Tables in Excel, this would …
In past posts, I have talked about a ‘database’ approach or how an Excel data analyst approaches data in their spreadsheet work or financial modelling. I come from an accounting and commercial background, and in these kind of roles unexpected report output needed mad moments before meetings and weekly and monthly deadlines was your life. …
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 »