Is there a way I can combine Rank and Unique to give me ranking of unique values from a column.
Tried this formula:
=RANK(U9,UNIQUE(FILTER($U$9:$U$18,U9:U18>0)))
but RANK doesn't seem to accept Unique as the range.
Thanks.
Tried this formula:
=RANK(U9,UNIQUE(FILTER($U$9:$U$18,U9:U18>0)))
but RANK doesn't seem to accept Unique as the range.
Thanks.