+ Reply to Thread
Results 1 to 12 of 12

Match multiple criterias and Return 3rd unique value

  1. 09-29-2019, 03:55 AM #1
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Match multiple criterias and Return 3rd unique value

    Hi all,
    I have match a date range and get 3rd unique value.


    But I am getting answer "C" Actual answer is "D". Excel book is attached.

    Please help me to get the correct answer.

    Regards
    Rudswa
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-29-2019, 04:58 AM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Match multiple criterias and Return 3rd unique value

    3rd unique value is A
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 09-29-2019, 05:52 AM #3
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Match multiple criterias and Return 3rd unique value

    I want the unique value. like in the series "A A A B B B C C C" , "C" is the third unique value.
    Reply With QuoteRegister To Reply
  4. 09-29-2019, 06:00 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Match multiple criterias and Return 3rd unique value

    Try this

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  5. 09-29-2019, 06:12 AM #5
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Match multiple criterias and Return 3rd unique value

    Not working as intended sir.
    Last edited by AliGW; 09-29-2019 at 06:14 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  6. 09-29-2019, 06:14 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,477

    Re: Match multiple criterias and Return 3rd unique value

    Quote Originally Posted by tim201110 View Post
    3rd unique value is A
    Tim - you have been asked before to provide the solution within the body of your post as well. Please do so for the benefit of those who cannot access attachments. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 09-29-2019, 06:15 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,477

    Re: Match multiple criterias and Return 3rd unique value

    Quote Originally Posted by rudswa View Post
    Not working as intended sir.
    In what way isn't it working? It is working perfectly here in the sample file.
    Reply With QuoteRegister To Reply
  8. 09-29-2019, 06:18 AM #8
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Match multiple criterias and Return 3rd unique value

    It is giving "3rd value in the series" not the 3rd "unique" value in the series.
    Reply With QuoteRegister To Reply
  9. 09-29-2019, 07:51 AM #9
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Match multiple criterias and Return 3rd unique value

    Quote Originally Posted by AliGW View Post
    Tim - you have been asked before to provide the solution within the body of your post as well
    i didn't provide a solution
    Reply With QuoteRegister To Reply
  10. 09-29-2019, 08:40 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,477

    Re: Match multiple criterias and Return 3rd unique value

    So what exactly does post #2 mean, then? You need to be clear.
    Reply With QuoteRegister To Reply
  11. 09-29-2019, 09:29 AM #11
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Match multiple criterias and Return 3rd unique value

    Helper column C used

    In C2 then copy down
    Please Login or Register  to view this content.
    In F11
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 09-30-2019, 05:12 AM #12
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Match multiple criterias and Return 3rd unique value

    Thanks it is working. But is it possible to do without the helper column.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Index match with multiple criterias and wildcards (not all criterias always used)
    By dunder in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2018, 07:09 PM
  2. Macro or Formula for multiple match criterias and return yes or no
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2016, 03:44 AM
  3. Count Unique Values based on multiple criterias
    By Dahlia in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-10-2016, 09:10 AM
  4. [SOLVED] How to count unique values using multiple criterias
    By Charmymay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2013, 11:27 AM
  5. [SOLVED] Formula to match two sets of criterias and then return text
    By clickclick in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-27-2013, 12:25 AM
  6. [SOLVED] Match 2 criterias and return a value
    By Spherous in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-23-2012, 04:43 AM
  7. Excel 2007 : need Unique vailue using multiple criterias
    By RAGH in forum Excel General
    Replies: 1
    Last Post: 08-24-2011, 04:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1