Hi,
Not sure if I fully understand, but here's a suggestion -
I think I'd use COUNTIF to determine the ties. eg:
=IF(COUNTIF(I7:I37,I8)1,"Tie","")
Then use RANK to determine the place, eg:
=RANK(I8,I7:I37)
Combination would be:
=IF(COUNTIF(I7:I37,I8)1,"Tie",RANK(I8,I7:I37))
Is this close to what you're after?
Regards - Dave.