Automatic Order Sorting in Excel

[osknows]

If a bet is placed then the Bet Ref in column T can also be output to an extra sheet 'Market1_MyBets' if Log Current Bets is selected.

You can then lookup the name of any horse by rank using the formula (the example below looks up the 3rd ranked horse and assumes the ranking is in column AA

=INDEX($A$5:$A$55,MATCH(3,$AA$5:$AA$55,0),1)

Once you have the horse name you can check whether a bet exists in the MyBets sheet as the horse name appears in column B.

=IF(ISERROR(MATCH("Horse Name",B:B,0)),"No Match","Match")

This is only a simple lookup and you may need to adapt it if there are multiple bets with the same horse.

[excelbet]

Tried your solution Osknows. It is perfect for my purpose. I can now 'back' or 'lay' any of the top 3 favs and my criteria will track each runner in any rank order they appear.
However, a new challenge has now emerged.
If a bet on Fav 1 is triggered, a Bet Ref No. appears but the 'Q' cell is open for multiple further bets to be triggered. Let's say that Fav 1 is in cell Q7 then the one of the rules for that Fav should be T16 =0 for it to work properly. But then if the rank order changes then a different option applies. It seems that for each permutation the Fav1 rule might be T14=0;T15=0;T16=0 but this can't be as there would be a conflict. Despite numerousl attempts to play around with multiple 'IF' statements I cannot find a solution.
Any further help would be much appreciated.
eb

[excelbet]

I should have explained that cells T14,T15,T16 replace T1=0 which count the Bet Ref cells. Each runner now has its own cell to count when a bet is placed.
e.g. T14=0 etc....

eb

[osknows]

Don't use column T to track bet references use either MyBets/Log Results or both

[osknows]

If you're still stuck outline what you are attempting to achieve an an excel sheet and PM me the details and I'll have a look.