ExcelBanter - Ranking with Duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Ranking with Duplicates (https://www.excelbanter.com/excel-worksheet-functions/173043-ranking-duplicates.html)

[email protected]

Ranking with Duplicates

I am trying to rank a list of 10 numbers and I know how to rank using
the RANK function. I have a problem though. When there are two (or
more) values that are the same, i want them to show .5 instead of
multiple 4s. i.e.

1356 9
1394 12
1252 6
1141 2
1374 10
1388 11
1152 3
1242 5
1256 8
1252 6
1158 4
980 1

There are two occurences of 6.. but I would them to each be 6.5 rather
than each of them being 6.

Any thoughts?

T. Valko

Ranking with Duplicates

See your other post

--
Biff
Microsoft Excel MVP

wrote in message
...
I am trying to rank a list of 10 numbers and I know how to rank using
the RANK function. I have a problem though. When there are two (or
more) values that are the same, i want them to show .5 instead of
multiple 4s. i.e.

1356 9
1394 12
1252 6
1141 2
1374 10
1388 11
1152 3
1242 5
1256 8
1252 6
1158 4
980 1

There are two occurences of 6.. but I would them to each be 6.5 rather
than each of them being 6.

Any thoughts?

All times are GMT +1. The time now is 01:59 PM.