Macro that ranks times .

Hello all ,

I have this macro that looks at cols BJ BL BN and should be finding the lowest time . I have done race 6 .
It doesn’t and im not sure why .

The macro works great with numbers or even decimal places .

Im guessing its not recognising the times in this format .

Once it finds the lowest time that horse gets ranked 1 , then finds next lowest different horse .
Once a horse is ranked the macro will not look at that horse again at all .

Sometimes there are cells with no times at all .

Any ideas would be great .

Thanks

Your times are not actual times, they are text strings. You will need to use proper times to perform any kind of ranking / calculation on them.

They should be entered as m:ss.00 not m.ss.00

Ok , thanks for that .

Enter this formula in BP2 and fill down

Formula:

Please Login or Register  to view this content.

Either use the new column for any additional formulas or copy the results and use PasteSpecial - Values to overwrite the original time column, if you do this you can then delete the formulas.

Thanks again , this function is now rounding as in this sheet enclosed .
Thanks .

Im open to any answers as i cant get the format jason.b75 mentioned . The function is not giving me the exact same result i have in col AN with the new :::: , etc .
Thanks .