Excel

[alliswell]

Hi everybody !
in column A are the names and in
column B is time h:mm:ss
in column B in some cells there is no time and left blank.
i want in column C the rank who arrived earliest in ascending order and sorted A & B column according to rank order.

THANKYOU everybody.

 

[Zot]

I think hen you use Excel Sort to sort time in ascending order, you will get the rank you wanted. The blank one will be at the bottom. Was it not working i your sort?

 

[Zot]

I think hen you use Excel Sort to sort time in ascending order, you will get the rank you wanted. The blank one will be at the bottom. Was it not working i your sort?

Looks like my keyboard is missing letters ?. Thanks for update.