• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Dashboard Formula Assistance

B

bexcelusr

New Member
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.
 

Attachments

This is amazing! thank you. a Follow up question...I've attached your version. What if I want to display the results without blank rows in between? Example.) Los Angeles would pull but it would be displayed below Boston in the attached.
 

Attachments

Another option without helper column

1] In "Sheet1" F3, formula copy across and down :

=IFERROR(INDEX(Sheet2!B$1:B$11,AGGREGATE(15,6,ROW(Sheet2!$B$1:$B$11)/(Sheet2!$C$1:$C$11>=$B$8)/(Sheet2!$C$1:$C$11<=$C$8)/(Sheet2!$D$1:$D$11>=$B$16)/(Sheet2!$D$1:$D$11<=$C$16)/(Sheet2!$E$1:$E$11>=$B$24)/(Sheet2!$E$1:$E$11<=$C$24),ROWS($1:1))),"")

2] See attachment

Regards
Bosco
 

Attachments

You must log in or register to reply here.
Back
Top