by Roger » Fri Jun 06, 2008 5:54 pm
I am new to this sort of spreadsheet, but I have had to solve the problem of the non-runner. Make a column in AA, with the formula
=IF(F5=0,"",F5)
Then you can use the formula
=F5=SMALL(AA:AA,1)
to find the favourite, even if there are non-runners. Change the 1 to 2, 3, etc. to get the 2nd and following favourites.
Note: All your mathematical formulas must still query column F directly.