minimum value out of a subset

[nabilqu]

I have two arrays. One with dates. One with numbers. I want a function to return the min of the numbers, but only using numbers corresponding to a given date. Thanks and much appreciated.

[Domenic]

Assuming that A2:A10 contains the date, B2:B10 contains the corresponding number, and D2 contains the date of interest, try...

=MIN(IF($A$2:$A$10=D2,$B$2:$B$10))

...confirmed with CONTROL+SHIFT+ENTER. If Column B can contain empty cells, try the following formula instead...

=MIN(IF($A$2:$A$10=D2,IF($B$2:$B$10<>"",$B$2:$B$10)))

...also confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!