+ Reply to Thread
Results 1 to 4 of 4

Creating a list of filtered data for quick reference

  1. #1
    Registered User
    Join Date
    05-09-2023
    Location
    Earth
    MS-Off Ver
    Office Professional Plus 2021
    Posts
    2

    Question Creating a list of filtered data for quick reference

    I have a PivotTable listing names and contribution amounts from a dataset. My source data contains some names that I wanted to exclude so I have filtered those out directly from the "PivotTable Fields" pane (not the PivotTable itself). I'd like to be able to see a quick reference list of the names that I excluded from my PivotTable, however, there are a LOT of names in the filtering list. Is there a way to add a chart/key/list of these filtered out names anywhere on my sheet?
    Attached Files Attached Files
    Last edited by roverby96; 05-10-2023 at 02:09 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Creating a list of filtered data for quick reference

    Hello roverby96 and welcome to Excel Forum.
    We might be better able to help if you could provide a sample.
    Information for attaching a sample workbook is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    05-09-2023
    Location
    Earth
    MS-Off Ver
    Office Professional Plus 2021
    Posts
    2

    Re: Creating a list of filtered data for quick reference

    Thank you - I have attached a sample document. In this document, you will see that I have excluded "Sample 4", "Sample 8", Sample 10", and "Sample 17" from my pivot table. I would like to know if there is a way I can create a list on the same sheet (like the list I manually created indicated with yellow highlight) that lists out these specific items for reference.
    Attached Files Attached Files
    Last edited by roverby96; 05-10-2023 at 02:11 PM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Creating a list of filtered data for quick reference

    Here is a fairly low-tech proposal.
    1. Produce a second unfiltered pivot table which could be hidden out of sight if desired
    2. Next to the second pivot table populate the corresponding first cell using: =MATCH(S4,A$4:A$23,0) and double click the fill handle to copy down
    3. The list of filtered samples is displayed using: =IFERROR(INDEX(S$4:S$22,AGGREGATE(15,6,(ROW(S$4:S$22)-ROW(S$3))/(ISERROR(T$4:T$22)),ROWS(D$1:D1))),"")
    Let us know if you have any questions.
    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. Cell reference to filtered data auto update as Filtered result changes
    By Irajoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2017, 02:17 AM
  2. Replies: 4
    Last Post: 11-14-2014, 05:32 AM
  3. Creating a Filtered List
    By ed2row5 in forum Excel General
    Replies: 14
    Last Post: 03-24-2014, 10:34 AM
  4. Replies: 3
    Last Post: 07-05-2013, 03:32 PM
  5. Creating a filtered populated list from another tab
    By Uvuriel03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 12:15 PM
  6. Creating a sub list from filtered data
    By Morrythemonk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2012, 04:24 AM
  7. How do I reference an Excel filtered list in a function?
    By gordo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2006, 03:40 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1