This is from a sailing results spreadsheet. Column J is the sailors result times and column K is their placings. I am using the formula below and this works fine if all the times are different. But if they are the same as in the example below it goes wrong, it should be as in column L

=1+COUNTIF($J$5:$J$20,"<"&J5),blank)

J................... K...........L

3286..............1...........1

3286............. 1...........1

3395..............3...........2

3932..............4...........3

4265..............5...........4

4428..............6...........5

Thanks