Results 1 to 3 of 3

Thread: Finding nth unique text value in a list

  1. #1

    Finding nth unique text value in a list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to develop a formula that returns the nth item (alphabetically) in a given list. Multiple occurrences of the same value are to be considered one occurrence so that only the number of unique entries are considered.

    I have attached a sheet that shows in tab 1 how I was able to achieve this numerically (not sure this is the best way but it seems to work). In tab 2 though, I am having trouble doing this alphanumerically.
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013

    Get Unique text Data from Column

    Quote Originally Posted by GTretick View Post
    I am having trouble doing this alphanumerically.
    You are looking Unique data, see my suggestion for a solution
    Array formula
    Code:
    =INDEX($E$5:$E$23;MATCH(0;COUNTIF($E$5:$E$23;"<"&$E$5:$E$23)-SUM(COUNTIF($E$5:$E$23;"="&C$4:C4));0)
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    That worked out well.

    Thanks for the help navic.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •