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?

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?