Equal ranks - but no gaps
Thanks a lot!! Worked like a charm!!!!!
"T. Valko" wrote:
If the values are unsorted:
=IF(A2="","",SUMPRODUCT(--(A2A$2:A$6),1/COUNTIF(A$2:A$6,A$2:A$6&""))+1)
--
Biff
Microsoft Excel MVP
"Toppers" wrote in message
...
Set B2=1
in B3 and copy down:
=IF(A3=A2,B2,B2+1)
"Thomas" wrote:
I checked quite a number of answers in this area, but couldn't find a
solution to my little ranking problem (column B is the ranking as I would
like to see it):
A B
1 Value Rank
2 1 1
3 1 1
4 1 1
5 2 2 <----- that being the 'tricky' part :)
6 3 3
Thank you very much!
Thomas
|