+ Reply to Thread
Results 1 to 2 of 2

Run a filter/query based on data validation drop down selection.

  1. #1
    Registered User
    Join Date
    12-11-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    42

    Run a filter/query based on data validation drop down selection.

    Hi there does anyone know if this is possible.

    I want a user to be able to select their site, then what filter they want to run. Upon selection of the specific filter/query it then populates the data on a the user form.

    I have set the following up but don't no what else to do or where to look for guidance. any assistance would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,366

    Re: Run a filter/query based on data validation drop down selection.

    Hope this works, put this on B5 on sheet "results"
    =IFERROR(INDEX(Data!$B$6:$B$18,SMALL(IF((Data!$B$6:$B$18<>"")*(COUNTIF(Data!$B$6:$B$18,Data!$B$6:$B$18)=$C$3),ROW(Data!$B$6:$B$18)-ROW(Data!$B$6)+1),ROWS($A$1:A1))),"")

    and double click on that cell to see the formula and push all together CTRL+SHIFT+ENTER button and last step copied down as necessary

    regards
    Azumi
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-31-2016, 01:55 PM
  2. Updating cells based on selection from drop down list data validation
    By excelstun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2016, 05:11 PM
  3. Replies: 7
    Last Post: 03-06-2015, 01:53 PM
  4. displaying list based on data selection in drop down of data validation
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2014, 12:51 AM
  5. [SOLVED] Updating cells based on selection from drop down list data validation
    By jingles9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 02:57 PM
  6. Replies: 1
    Last Post: 12-20-2011, 02:47 PM
  7. validation list - filter based on selection
    By jen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2006, 09:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1