Hello guys,
Hope you will be able to give me a hand. I have a pretty vast database which I populated through VBA from a certain number of worksheets. I now need to create a table which shows min, max and average for each location given x, y or z condition. So far I only approached it by creating a secondary table with each range address and then using INDIRECT, but this would require extra work on the database (insert a function to sort out locations alphabetically and within each Range.Location sort out by conditions (note. A, B and C are not in alphabetic order)) and is also very ugly.
I was wondering whether you had any more elegant ideas?
I attached a sample example of my spreadsheet hoping it will help!
Thank to whoever will spare the time to help me.
Best,
Carlo
Bookmarks