harpscardiff

I have also been away. You are very nearly there!

You would have been limited to 7 levels of If statements, so you will
have to use the number of the rank if greater than 4 and add the "th"
to it. Then do the top 3 as before, the second element will need to be
done separately, see below:

I have made a couple of assumptions, but perhaps you can try the
following.....

=IF(RANK(B382,$B$382:$B$390)3,CONCATENATE(RANK(B3 82,$B$382:$B$390),"th"),IF(RANK(B382,$B$382:$B$390 )=3,"3rd",IF(RANK(B382,$B$382:$B$390)=2,"2nd",IF(R ANK(B382,$B$382:$B$390)=1,"1st"))))

This will allocate the 1st to 10th Ranking. For your Points scoring,
you may need to split this up into 4 points columns, one for each
table, then total them.

=IF(RANK(B382,$B$382:$B$390)6,0,IF(RANK(B382,$B$3 82:$B$390)=6,1,IF(RANK(B382,$B$382:$B$390)=5,2,IF( RANK(B382,$B$382:$B$390)=4,3,IF(RANK(B382,$B$382:$ B$390)=3,4,IF(RANK(B382,$B$382:$B$390)=2,8,IF(RANK (B382,$B$382:$B$390)=1,10)))))))

I have assumed you want to always show the rank, that points are only
awarded to the top 6 in each table, and that you will be able to insert
another column, or a separate table to calculate points for each
ranking table)

Hope this Helps

Steve