Hi everybody,
I would need some help on this formula that has been a head-scratcher for me. I have a list of text cells and would like to extract unique values to be able to put them on an array so that I can do sumifs on them (like a pivot table).
The list I have would look like this:
Component A
Component B
Component C
Component A
Component B
Component B
Component C
I would like to rank them from 1 to XXX depending on how many there are to be able to put them in an array. I also want for similar names to have a similar rank and the ranks to go up 1 by 1 (so no 1 and then 3 if there are two first similar names etc ...).
I tried doing this with a classic COUNTIF(List;"<"&End of list)+1 but it doesn't work as it considers similar names as same rank but ex-aequo so I end up with 1, 1, 3, 3, 3, 3, 3, 3, 3, 10 instead of 1,1, 2,2,2,2,2,2, 2, 3.
Thank you so much for your help!
Bookmarks