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?