Applying a rank to horses in different races

[Av8]

Hi everyone, I'm hoping some of the Excel masters on here may be able to help? I'm trying(!) to analyse some horse racing data over a number of years and would like to assign a rank to each horse, for each race, based on its price in the betting markets.

I have attached an example image of the data I have (basically hundreds of different races) and was wondering if it's possible to use the date and time of the race (columns A and H) to assign a rank for each horse based on its price in column T.

Each horse does already have a rank assigned (column R), however this is not based on the price I would like. For example, the race at 6.05pm has three horses ranked at 3, however their prices in column T are different.

I hope this makes sense, and I'm sure it's an easy formula for the more experienced so I'd really appreciate if anyone could help at all - even if it's just to say it can't be done.

Many thanks in advance

 

[vmjan02]

Try this

consider that column U is all blank give header as Date&Time
add this formula
=A2&H2 -- (adding Data and Time) (A column is Date and H column is time)

Rank Output in Column V
add this formula
=COUNTIFS(U:U,U2,T:T,">"&T2)+1 (Here column T is Prize)

 

[Av8]

Thanks very much, that is almost exactly what I was looking for, however it ranks in reverse order. Sorry my fault for not being specific but I was hoping to rank lowest price as number one. For example the first horse on the list in the pic would be number one as it is the lowest price. Really appreciate your help

 

[vmjan02]

change this to

=COUNTIFS(U:U,U2,T:T,"<"&T2)+1

Thanks for the feed back. Glad that I could help

 

[Av8]

You're a diamond - works perfectly

Thanks ever so much, all the best!