Hi,

I have a table to rank which has a lot of equal values. Short example:

Input table Output using RANK() Desired output
a 3 d
d
b 4 c
c
c 5 b
b
d 6 a
a or e
e 3 n/a a
or e

If I use the normal rank function it can only prioritise different values.
When it sees equal values it returns the first value and then error for the
rest. How I can get it to display the value I need? I dont care whether a
or e comes first in the list so no alphabetical ordering or further filtering
needed.

Thanks

Sorry I wrote completely the wrong thing. This works fine. Ignore this
question

"LiAD" wrote:

Hi,

I have a table to rank which has a lot of equal values. Short example:

Input table Output using RANK() Desired output
a 3 d
d
b 4 c
c
c 5 b
b
d 6 a
a or e
e 3 n/a a
or e

If I use the normal rank function it can only prioritise different values.
When it sees equal values it returns the first value and then error for the
rest. How I can get it to display the value I need? I dont care whether a
or e comes first in the list so no alphabetical ordering or further filtering
needed.

Thanks