Guys
I ahve the following spreadsheet
What I have been doing is highlighting the top 3 for each race in the AVLR and MAXLR columns manually using Conditional Formatting. Is there any way this could speeded up with a formula as somedays there are quite a lot of races and I have to use Conditional Formatting to highlight the top 3, three times for each race as the numbers are from a horse's last race, AVLR, MAXLR, second last race AV2, MAX2, and third last race AV3 abd MAX3.
Thank you
Rob
I ahve the following spreadsheet
What I have been doing is highlighting the top 3 for each race in the AVLR and MAXLR columns manually using Conditional Formatting. Is there any way this could speeded up with a formula as somedays there are quite a lot of races and I have to use Conditional Formatting to highlight the top 3, three times for each race as the numbers are from a horse's last race, AVLR, MAXLR, second last race AV2, MAX2, and third last race AV3 abd MAX3.
Thank you
Rob