Way out there in the umteenth decimal place, the numbers are not the same.
Use the ROUND function to round for four decimal places before doing the
rank. For example, I added a column with the numbers rounded to 4 decimal
places ("=ROUND(A2,4)"). Note how places 7 & 8 are now the same.


TOTAL Total Place ROUNDED TOTAL Total Place
35.7000000000 1 35.7000000000 1
34.8000000000 2 34.8000000000 2
34.7000000000 3 34.7000000000 3
34.6000000000 4 34.6000000000 4
34.4000000000 5 34.4000000000 5
34.3000000000 6 34.3000000000 6
33.9000000001 7 33.9000000000 7
33.9000000000 8 33.9000000000 7
33.6000000000 9 33.6000000000 9
33.5000000000 10 33.5000000000 10
33.4000000000 11 33.4000000000 11
33.4000000000 11 33.4000000000 11
33.3000000000 13 33.3000000000 13
33.2000000000 14 33.2000000000 14
33.2000000000 14 33.2000000000 14
33.1000000000 16 33.1000000000 16
32.6000000000 17 32.6000000000 17
31.8000000000 18 31.8000000000 18


--
-------------------
If toast always lands butter-side down, and cats always land on their feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )


"Blobbies" wrote:

For the life of me, I can't understand why this is happening ..... Using
Excel 2007 on XP.

I have a series of gymnastics results. Sometimes an equal score will
produce a tied rank, and sometimes, for some reason, it will produce separate
rankings .... Weird!! Sample pasted below - all these results are produced
by the formula "=RANK(P22,$P$22:$P$39,0)" (obviously the P22 changes on each
row!).

Please note placings 7 and 8, and 11, and 14!!?? I would like to end up
with all eual scores producing a tied rank! I suspect there will be a simple
answer, and i thank you in advance!!



Mike
New Zealand

TOTAL Total Place
35.7000 1
34.8000 2
34.7000 3
34.6000 4
34.4000 5
34.3000 6
33.9000 7
33.9000 8
33.6000 9
33.5000 10
33.4000 11
33.4000 11
33.3000 13
33.2000 14
33.2000 14
33.1000 16
32.6000 17
31.8000 18