+ Reply to Thread
Results 1 to 4 of 4

Filter based on a value form a table column items

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    422

    Filter based on a value form a table column items

    I have a table of datas as per attached with several rows and columns. I want to filter data on the table based on items on one column.

    Can I set it up in such a way that the filter seperated and the remaining columns are filtered out. (may be using a
    pivot table)

    See the desired output.

    (So the final output table should have one column less than the original table and the unique items of that table should be displayed on a dropdown list above the table)

    THanks in advance.
    Attached Files Attached Files
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,237

    Re: Filter based on a value form a table column items

    Please try VBA
    Press Alt+F11
    Paste below code at Sheet1

    Please Login or Register  to view this content.
    or formula at A3:C259

    =IF($A$1="All",INDEX(Original!B:B,ROW()),IFERROR(INDEX(Original!B:B,AGGREGATE(15,6,ROW(Original!$A$3:$A$259)/(Original!$A$3:$A$259=$A$1),ROWS(A$3:A3))),""))
    Attached Files Attached Files

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,472

    Re: Filter based on a value form a table column items

    How about in A3 then fill all table:

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    422

    Re: Filter based on a value form a table column items

    Thanks Bo_Ry and bebo021999

    I was after a solution without VBA and this solution this exactly that.

    It was very well done, I will still need some time to figure out how its been executed.

+ 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. Filter Pivot Table Items Based On Named Range
    By excelakos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2020, 12:58 PM
  2. [SOLVED] Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2019, 03:08 AM
  3. Replies: 5
    Last Post: 05-02-2018, 12:07 PM
  4. [SOLVED] Rank items in Pivot table from high to low and low to high based on the filter selected
    By jholiday78 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-19-2017, 11:22 AM
  5. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. [SOLVED] Filter based on a column of items
    By Pasko1 in forum Excel General
    Replies: 1
    Last Post: 08-22-2005, 07:05 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