Ranking Equal Values
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 |
Ranking Equal Values
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 |
All times are GMT +1. The time now is 01:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com