Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-27-2017, 07:36 AM
Exceluser Exceluser is offline Dynamic Dashboard w/ Search Criteria Windows 7 64bit Dynamic Dashboard w/ Search Criteria Office 2013
Novice
Dynamic Dashboard w/ Search Criteria
 
Join Date: Apr 2017
Posts: 2
Exceluser is on a distinguished road
Default 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.
Attached Files
File Type: xls Sample.xls (30.0 KB, 12 views)
Reply With Quote
 



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
Dynamic Dashboard w/ Search Criteria 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft