Dynamic Dashboard w/ Search Criteria
I could use some assistance on this as I've not been able to come up with a solution. I've attached file as it's easier to view and understand what I am trying to accomplish. What I need to do is come up with a formula that displays data based on three criteria selected. When the criteria range changes, the results will filter and change based on what I've selected. I want the city Results to populate with the cities based on the criteria ranges I've selected. For example if population range is 90K-100K and Avg. Income range is 90K-110K and % of Pop w/ Bachelors Degree is 67%-82% I want all cities in my data set that meet the specified criteria to display. If there are changes to the search criteria, say you change the Population to be 80K-120K or decrease the Avg. Income, then the city results would change and filter based on what you've selected. Thank you thank you for any help on this.
|