Please see attached example. If I have an excel data table that has 40 columns and 50,000 rows of data of locations that receive rent. I am using this data to create a comp list. I would like to create an efficient way to look at the annual rent averages based on specific criteria in a specific order. I have looked at user forms, combo boxes, but I have not yet attempted to move forward. I would like input on the most efficient way to do this.
Thanks,
Jake
Bookmarks