Thread
:
Values
View Single Post
#
2
Bernd Plumhoff
Posts: n/a
=INDEX({10,8,6,4,2},RANK(A2,$A$1:$A$5,FALSE)+COUNT IF($A$1:A2,A2)-1)
if you want different numbers for equal values in A1:A5, otherwise:
=INDEX({10,8,6,4,2},RANK(A2,$A$1:$A$5,FALSE))
HTH,
Bernd
Reply With Quote