Hi, is it possible to identify the "nth" unique entry in a list?
In other words: Column A has 8 different unique entries, some duplicated.
So for rows 7 to 8 where the Info is "charlie":
Col B "nth unique entry": charlie is the 5th unique entry on the list (i.e. 1,2,alpha,beta, charlie)
Col C "nth with count": there are 2 duplicates of charlie, so the 1st one (row 8) will be 5.1. And the second row (row 9) 5.2
If it helps, the info in Column is sorted A-Z
Hope this helps
In other words: Column A has 8 different unique entries, some duplicated.
So for rows 7 to 8 where the Info is "charlie":
Col B "nth unique entry": charlie is the 5th unique entry on the list (i.e. 1,2,alpha,beta, charlie)
Col C "nth with count": there are 2 duplicates of charlie, so the 1st one (row 8) will be 5.1. And the second row (row 9) 5.2
If it helps, the info in Column is sorted A-Z
| Book3 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Info (a-z) | "nth unique entry" | "nth with count" | ||
| 2 | 1 | 1 | 1.1 | ||
| 3 | 2 | 2 | 2.1 | ||
| 4 | 2 | 2 | 2.2 | ||
| 5 | alpha | 3 | 3.1 | ||
| 6 | beta | 4 | 4.1 | ||
| 7 | charlie | 5 | 5.1 | ||
| 8 | charlie | 5 | 5.2 | ||
| 9 | delta | 6 | 6.1 | ||
| 10 | echo | 7 | 7.1 | ||
| 11 | echo | 7 | 7.1 | ||
| 12 | echo | 7 | 7.1 | ||
| 13 | foxtrot | 8 | 8.1 | ||
| 14 | foxtrot | 8 | 8.2 | ||
Sheet1 | |||||
Hope this helps
