I need to reproduce the functionality of a pivot table without using pivot tables. I'd much rather do this with functions rather than macros (easier for me to understand), but if a macro is the only way to go, please provide that solution.
Attached sheet explains the situation best. I'll have one data set, from which dozens of different tables will be produced. This data will be deleted and replaced periodically, so dynamic formulas are needed.
It's icing on the cake if I can 1) set up a drop-down selector that allows me to dynamically change the horizontal and vertical parameters and 2) put the data in descending order.
Thanks for the help! Happy to answer any clarifying Q's.
Bookmarks