+ Reply to Thread
Results 1 to 4 of 4

Extract unique text values from a filtered list

  1. #1
    Registered User
    Join Date
    10-29-2008
    Location
    UK
    MS-Off Ver
    365 (Version 2202)
    Posts
    14

    Extract unique text values from a filtered list

    Dear Experts

    I have a task list which is organised by category and filtered by date. Whilst it is filtered I'd like to extract a list of unique values from a column (Col C in attached sample) other than the one that is filtered (Generally Col J). Despite searching I haven't found a way to do this. Does anyone know how?

    Sample sheet attached.

    Thanks in advance
    LJ
    Attached Files Attached Files
    Last edited by ljerromes; 10-22-2015 at 10:37 AM.

  2. #2
    Registered User
    Join Date
    10-29-2008
    Location
    UK
    MS-Off Ver
    365 (Version 2202)
    Posts
    14

    Re: Extract unique text values from a filtered list

    Any ideas on this? I think an array formula is required but don't how to write it. Any help appreciated.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extract unique text values from a filtered list

    Not sure where you want this list

    enter in M5 and copy down

    =IFERROR(INDEX($C$5:$C$14,MATCH(0,INDEX(COUNTIF(M$4:M4,$C$5:$C$14),,),)),"")
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract unique text values from a filtered list

    I downloaded your file but there is no active filter applied.

    When you say filter do you mean autofilter or a table filter or something else?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. [SOLVED] Counting Unique Text Values When Filtered
    By mzagha in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-30-2019, 05:17 AM
  2. [SOLVED] Extract a List of Values Filtered by Criteria
    By mcmahobt in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2014, 09:04 AM
  3. How to count unique values in filtered list?
    By Cayenne in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 10-23-2014, 04:58 PM
  4. [SOLVED] automatically extract unique values from a list
    By labogola in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-07-2014, 10:54 AM
  5. [SOLVED] Extract unique values from a table and list along a row
    By doctorblyth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2013, 04:33 PM
  6. Filter for unique values on an already auto-filtered list?
    By dylanemcgregor in forum Excel General
    Replies: 1
    Last Post: 01-11-2010, 07:25 PM
  7. Counting unique text entries in a filtered list...
    By SOS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2006, 12:31 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