+ Reply to Thread
Results 1 to 6 of 6

Unique and Filter multiple criteria from SAME column

  1. #1
    Registered User
    Join Date
    12-22-2023
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    48

    Unique and Filter multiple criteria from SAME column

    Hi everyone,

    Trying to combine Unique and Filter and use the same column to pull multiple criteria. Have tried below formulas. Attaching a sample as well.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Tried this as well but knew this was a long shot

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Any hint what I am doing wrong?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Unique and Filter multiple criteria from SAME column

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,004

    Re: Unique and Filter multiple criteria from SAME column

    Removed. My method is the same as Fluff13.
    Last edited by windknife; 02-28-2024 at 11:31 AM.

  4. #4
    Registered User
    Join Date
    12-22-2023
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    48

    Re: Unique and Filter multiple criteria from SAME column

    Awesome! This worked. Thanks!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Unique and Filter multiple criteria from SAME column

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Unique and Filter multiple criteria from SAME column

    Glad to help & thanks for the feedback

+ 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] Help with UNIQUE/FILTER array based on multiple date criteria
    By jk2391 in forum Excel General
    Replies: 4
    Last Post: 08-31-2023, 02:51 PM
  2. Replies: 7
    Last Post: 12-10-2021, 02:17 PM
  3. [SOLVED] Unique filter using multiple filters in one column
    By kris01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2021, 01:34 PM
  4. [SOLVED] Unique values in a column - multiple criteria
    By Travman1986 in forum Excel General
    Replies: 6
    Last Post: 04-01-2018, 05:50 AM
  5. [SOLVED] Find unique cells in column -> Sum another column based on multiple criteria
    By mjoc9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2015, 09:29 AM
  6. Replies: 6
    Last Post: 07-24-2015, 11:40 PM
  7. Filter multiple criteria to only keep unique values
    By albardit18 in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 09:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1