sorry for the late reply steve, been off for a few days.

Also apologies for the lack the detail in my query. But what you got
was spot on. but i'll just confirm what i need just to confirm:

1. I got 4 catergories - cat 1, 2, 3 and 4.
2. Next to each catergoy i got another column called position.
3. The position column holds the rank for each person within that
catergory, in total there are 4 position columns, in each catergory
they could have different ranks.
4. The rank should go from 10th down to 1st, should this formula work
or are too many nested ifs?


Code:
--------------------

=IF(B382=0,"",IF(RANK(B382,$B$382:$B$390)10,"10th ",IF(RANK(B382,$B$382:$B$390)=9,"9th",IF(RANK(B382 ,$B$382:$B$390)=8,"8th",IF(RANK(B382,$B$382:$B$390 )7,"7th",IF(RANK(B382,$B$382:$B$390)6,"6th",IF(R ANK(B382,$B$382:$B$390)5,"5th",IF(RANK(B382,$B$38 2:$B$390)4,"4th",IF(RANK(B382,$B$382:$B$390)=3,"3 rd ",IF(RANK(B382,$B$382:$B$390)=2,"2nd",IF(RANK(B382 ,$B$382:$B$390)=1,"1st","")))))

--------------------


5. The person with the higest rank in each column get 10 points, 2nd
highest, 8, 4, 3, 2, 1. This will be in column at the end of the
table.


Hope it make more sense?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=571715