Find Min Date based on criteria

Hi,

I have searched the web for 30 min banging my head against the wall trying to get various formulas to work for this. I included a file to explain my problem.

On the Min Formula tab I have 5 green cells where I need a formula to look at the fruit on the data tab and bring back the minimum date (earliest date) that is in a column far off to the left.


Can someone help me with this?

Hi Callskier,

No formulas needed just a simple pivot table where you show the Min instead of sum or couunt or...

I don't see a second tab, nor any green cells...

but basically try something like this:

=MIN(IF($G$1:$G$19="Apple",$A$1:$A$19))

You can replace "Apple" with a cell reference containing the word.

Then confirm the formula with CTRL+SHIFT+ENTER not just ENTER and copy down..

I can't see any green cells......

Standard approach would be to use an "array formula"

=MIN(IF(G1:G19="Apple",A1:A19))

Formula needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

see attached.