How to find the earliest or latest date with criteria selection?

Hi all,

I'm new here and I need help.

I want to find the earliest date from a range of selection with criteria. See attached file.


Any help or suggestion is very much appreciated.

**J.B**

Try array formula, with C1 contains criteria from column A:

=MIN(IF($A$2:$A$9=$C$1,$B$2:$B$9,""))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Replace MIN with MAX to get latest date