Ranking with Duplicates

S

shocksterman

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking with Duplicates 4
Ranking with Duplicates 1
Duplicate Numbers in Ranks 2
Ranking 3
Ranking 2
RANK - dont include zeros 5
RANKING alters when data is filtered 4
Ranking (Look for previous ranking) 3

Top