Hi there. This is my first post on the forum so I do hope I'm following all the protocols correctly. I would really appreciate some help as my brain is almost worn out from trying to sort out this formula!

I'm using an Excel spreadsheet to analyse data for horse racing results.

I've come across a problem, which I thought I had a formula for, but
in real life it's falling short of what I need - I've obviously done something too simplistic.

In the attached spreadsheet, the columns I am interested in are L & M - Price differences (expressed in decimal betting odds) from the preceding horse and the following horse in the race. What I have done all looks ok until we get the issue of JOINT favourite horses where the BSP (that is the starting price in column O) is the same for 2 or more horses in the same race). I have highlighted an example of this in green -
rows 82 and 83. Sometimes there may be 3, 4 or even more joint favourites in a race. When this occurs I would need to see the columns L & M being identical for all the joint favourites in the race. So in this example, in column L it should read 5.01 for both Black Baccara and Dorothys Dancing and in column M it should read 9.74 for both these horses.

I do hope this makes sense and that someone can put me out of my misery!

Thanks
Juliet