Find MIN/MAX date in a range if it matches criteria of other columns

Question

Column A is date

Column B is criteria

I want to find the MIN date for each criteria. I tried using Ctrl+Shift+Enter with

=MIN(MATCH(B2,B:B,0))

but thats not quite right because I need to refer to Column A somehow to get the date. I'm pretty confident this can be done with arrays, so any help would be great.

Answer 1

Try this (array formula):

=MIN(IF(B2=B:B,A:A))