+ Reply to Thread
Results 1 to 5 of 5

Filtering data using Data validation list

  1. 01-07-2022, 09:58 AM #1
    Vj Raj
    Vj Raj is offline
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Filtering data using Data validation list

    Hey guys,

    I am not sure if this is possible, but, I am trying to populate a table based on a selection in a Data validation List. I have attached a Sample file showing what I am trying to achieve. The sheet "Data" has a set of data and sheet "Filter" is where I need to have the filtering happen based on "Region". When I select "East" the table should populate all the rows with region "East" and the same should happen for other regions as well. Is this even possible in excel with VBA or something?

    Any help is appreciated.

    Thanks in advance

    VJ
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-07-2022, 10:08 AM #2
    Vj Raj
    Vj Raj is offline
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Re: Filtering data using Data validation list

    Also, I do not have a 365 subscription. So I cannot use FILTER function with my version of Excel.
    Reply With QuoteRegister To Reply
  3. 01-07-2022, 10:14 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Filtering data using Data validation list

    But you do have AGGREGATE, so:

    =IFERROR(INDEX(Data!A:A,AGGREGATE(15,6,ROW(Data!$A$2:$A$20)/(Data!$A$2:$A$20=$C$2),ROWS(A$5:A5))),"")

    copied across and down.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 01-07-2022, 10:29 AM #4
    Vj Raj
    Vj Raj is offline
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Re: Filtering data using Data validation list

    Wow. This is great. Thanks Glenn. Really appreciate it

    VJ
    Reply With QuoteRegister To Reply
  5. 01-07-2022, 10:31 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Filtering data using Data validation list

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Restrict data validation list selection based on another table - dependent data validation
    By arezaeia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. [SOLVED] How do I link Dropdown List (data validation) with filtering data from a table?
    By Trishux25 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-29-2015, 10:17 PM
  3. HELP: How do I link Dropdown List (data validation) with filtering data from a table?
    By Trishux25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2015, 08:36 PM
  4. looking to arrange filtering in data validation list
    By AVM in forum Excel General
    Replies: 10
    Last Post: 06-10-2014, 05:35 AM
  5. Data validation list - logical filtering
    By Lizlien in forum Excel General
    Replies: 6
    Last Post: 10-24-2013, 03:13 PM
  6. [SOLVED] How to use value in cell after filtering data, using data validation list method
    By SAGAR KHOLLAM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2012, 02:01 AM
  7. Filtering Data Validation List Without Using Advanced Filter
    By idlewild in forum Excel General
    Replies: 3
    Last Post: 05-15-2011, 11:46 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1