Find Ranks

[sachinattri]

1.45
Rank :


2.0
3.2
1.3
2.0


How do I find out what the RANK of 1.45 is after comparing it to th
rest of the data?

Also is there a way to RANK each one with 1 being the largest value.

Thank yo

 

[sachinattri]

Sorry but I forgot to add that these ROWS are not together, they hav
some more rows in between them so I cant use the function "RANK" or ma
be use it but I dont know how. Thank

 

[Frank Kabel]

Hi
is there a logic in your data layout. e.g. 1 value and one other row.
You may also consider defining a name for your value range and use this
in the RANK function