John

I can't give you a good, concrete answer because I don't know how your data
is arranged. However, if you have a score in column B, a name in column A,
then a formula like this column C would produce the result

=IF(B1=LARGE($B$1:$B$10,1),-2,IF(B1=LARGE($B$1:$B$10,2),-1,IF(B1=LARGE($B$1:
$B$10,9),1,IF(B1=LARGE($B$1:$B$10,10),2,0))))


--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"jp" wrote in message
...
Dear all

I posted this question on 3rd of Oct but it has dissappeared! I know there
have been problems with the servers so I am not aware of any solutions.
Sorry but here goes again.


In my golf spreadsheet I have a test for the 12 players as follows

If you are first then you lose 2 shots
If you are second you lose 1 shot
If you are last you get 2 shots back
and
If you are second last you get one shot back (even if there are a slack
handfull of you!!)

My problem is not 1st 2nd or last but second last!!

How do I code the following to cope with joint 9th!!?

Cheers

John
North Yorkshire UK



=IF($F$180=12,"",IF(F156=$F$175,"-2",IF(F156=$F$175+1,"-1",IF(F156=$F$176,"+
2",IF(AND(F156=$F$176-1,$F$177=1),"+1","")))))