Find the Fav

[macarony]

Is it possible to us an if statement to establish the fav? I have wrote a little sheet that use simple if statements not VBA.

[osknows]

Assuming the current BACK odds in column F are used to determine the odds use the following in row 5 and copy down

Code: Select all

=IF(F5=MIN($F$5:$F$55),"Fav","")

If more than 1 selection has the lowest odds then "Fav" will appear multiple times.

[macarony]

Thanks for the help I was wondering if the word FAV is a trigger or can be used to find the current favourite?

[osknows]

Thanks for the help I was wondering if the word FAV is a trigger or can be used to find the current favourite?

No I just used the word Fav as an example, you can replace "Fav" with any word you like or a numeric value instead. eg =IF(F5=MIN($F$5:$F$55),1,0)