Finding nth unique text value in a list

G

GTretick

Member
Joined
Jul 29, 2015
Messages
42
Reaction score
0
Points
6
Location
Canada
Excel Version(s)
365
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.
 

Attachments

  • Text Rank.xlsx
    22.3 KB · Views: 62
Get Unique text Data from Column

GTretick said:
I am having trouble doing this alphanumerically.
Click to expand...
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)
 

Attachments

  • GTretick-navic.xlsx
    25.5 KB · Views: 108
That worked out well.

Thanks for the help navic.
 
You must log in or register to reply here.
Back
Top