Hello,
I was able to come up with a formula based on one criteria, but found it's more challenging to extract the data based on multiple criteria. What I'm looking to do is extract the data from the 'data' tab to the 'development dashboard' based on the construction status and year. The top 5 properties needs to be extracted in descending order for a construction status of "completed" and year of "2016". Thank you so much!!
Extract data based on two criteria in order.xlsx
Bookmarks