I need help with the following I posted this a year or so ago and my
computer crashed
In column E, I have difference times like 14.5 seconds and other cells
in same column could have 12.1 or 13.4 and some cells are blank, it
is a score card for track and field program
in column AI it should come up as a number 3 or 2 or 1 as per sample

=IF(E8="",0,IF(E8=MIN(IF($AE$6:$AE$60,$AE$6:$AE$6 )),2,IF(E8=MAX($E
$8:$E$35),1,IF(OR(E8<$AE$6,AND($AE$6=0,E80)),3))) )

It doesn’t work out I hope this makes sense
i am happy to email the sheet to someone to help me