Find MIN/MAX date in a range if it matches criteria of other columns
excel, excel-formula
Solution
Try this (array formula):
=MIN(IF(B2=B:B,A:A))
Problem
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.