Hi
in C2 enter the following array formula (entered with CTRL+SHIFT+ENTER)
=IF(B2=MIN(IF($A$2:$A$100=A2,$B$2:$B$100)),B2,"")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

Daniel Bonallack wrote:
I've tried to search for MIN with multiple criteria, but had
difficultly applying the examples

I record running times, and I want to get the best time for a given
day. So column A has the date, and column B has the number of
seconds. Column C should show the day's best time (so it would be
repeated for each row where the date is the same).

For example, A2:A10 all have today's date. B2:B10 have times in
seconds. If B5 is the fastest time, the time in B5 would display in
C2:C10.
Cells A11:A23 have yesterday's date - etc - I need the C2 formula to
copy down.

Thanks in advance

Daniel