Hello
could someone please help me with this 'auto find average of 4 fastest
times' question,
formula is and works fine.

=AVERAGE(IF('previous race results'!$A$1:$A$861=B36,'previous race
results'!$B$1:$B$861))

where B36 is the persons name column and A1 to A861 have the times,
currently I delete any more than 4 times for each person (very time
consuming). Is there a way to do this average of the 4 fastest times
regardless of the number of times in A1 to A861 for each person.

thanks in anticipation
Ditchy
Ballarat
Australia