+ Reply to Thread
Results 1 to 7 of 7

List unique values based on multiple criteria

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    41

    List unique values based on multiple criteria

    Hi all,

    I am looking for some help in returning unique data based on multiple criteria..

    I would like to list values in column A of the 'Info' sheet based on criteria from the 'WO Output' sheet. I need unique values from the 'InternalBarcode' field to be listed if the 'Description' field = 'Yellow 10kg 70-90mm' and the 'GradeType' = 'Waste' (see attached sheet).

    I hope this makes sense and that someone can help me achieve this..

    Many thanks in advance,

    TM

    Book2.xlsx
    Last edited by tangmere.milli; 01-22-2016 at 07:50 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: List unique values based on multiple criteria

    Try

    A2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by shukla.ankur281190; 01-22-2016 at 07:19 AM. Reason: Refernce Wrong!!!
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    41

    Re: List unique values based on multiple criteria

    Thanks Ankur, but this returns a circular reference error..

    I have changed the
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    and this returns data, but gives me the following values if I drag the formula down..

    2545400
    2545537
    2545549
    2545653
    2545818

    And unfortunately, these values do not match the criteria from the table.

    TM.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: List unique values based on multiple criteria

    Hi TM

    Yes there should be one row blank avoiding the duplicate.

    Have a look at attachment and change ranges according you need.
    Attached Files Attached Files

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: List unique values based on multiple criteria

    I think Ankur was edit the formula later, if you modified Info!$A$2:A2 as Info!$A$1:A1 it is working fine for me
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Registered User
    Join Date
    01-07-2014
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    41

    Re: List unique values based on multiple criteria

    Ankur, you are a star my friend!

    This works perfectly!

    Many thanks for sorting this out, very much appreciated.

  7. #7
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: List unique values based on multiple criteria

    Happy to help you and thanks for 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. Reading unique values based on multiple criteria
    By bscheideman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2015, 12:45 PM
  2. Count unique values based on multiple criteria
    By Jonathan11235 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-19-2015, 10:02 PM
  3. List Unique Values Based On Criteria
    By tangmere.milli in forum Excel General
    Replies: 5
    Last Post: 03-16-2015, 09:49 AM
  4. [SOLVED] List unique values corresponding to certain criteria from across multiple sheets
    By andredl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2014, 12:37 AM
  5. [SOLVED] Counting Number of Unique Values in a List based on Criteria
    By greencroft in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-03-2014, 04:00 AM
  6. [SOLVED] Extract unique values out of list based on an extra criteria
    By sven1975 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 05:02 AM
  7. Replies: 2
    Last Post: 09-28-2011, 08:43 AM

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