Thanks for all the replies, the function I was looking for was RANK() it worked perfectly!

Cheers,

Scott

Ah sorry about that - replies flying in!

I'll have a look and see if Rank() is what I need - sounds promising tho!

I dont think that will work - allow an example with more realistic data

Name Mark Position

Smith 76 ...