Please see image below the "Numbers" column are the values I want to rank.
The "Preferred Ranking" is what I want as the results except I am having real trouble trying to get there!
Do you have any idea how I can achieve this? Thanks in advance.
>Solution :
=SUM(1*(A1>=UNIQUE($A$1:$A$17))) and drag it down or =MAP(A1:A17,LAMBDA(z,SUM(1*(z>=UNIQUE(A1:A17))))) to spill whole result at once.
Result:
