Thanks for your quick reply squiggler47, your formulas are every bit as complicated as I expected. I'm pasting your formulas into cell AC7, and I'm hoping to get the result of 30 for the winner. Unfortunately, I'm only getting a blank cell.

I'm wondering if I made it clear what I am after. I'm hoping to end up with 30 in cell AC7, 39 in AC9, 24 in AC11, and so on, so that the commentator can just read off this Results block "And the winner is number 30, Rider 30 on Horse 30, and in second place is number ........".

Your formulas don't seem to reference column A where the competitor numbers are, nor column Z where the 1st to 6th rankings are. Hoping I'm making myself clear. Thanks.