#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Is it like shown in the attached?
|
#3
|
|||
|
|||
Thank you thank you thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Use CSV as search criteria for Outlook search folder | lonesoac0 | Outlook | 0 | 03-07-2016 02:31 PM |
Dynamic Dashboard on company intranet | LabProARW | Excel Programming | 0 | 12-16-2014 07:46 AM |
Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
Display if search criteria is not met | meppwc | Excel | 2 | 03-23-2013 10:48 AM |
Search Folder sent to criteria | markstro | Outlook | 0 | 12-20-2011 02:47 PM |