Get Earliest Date from Range Given a Second Criteria

Manuel W.

Hello,
I have a column of Dates and a column of Names.
What formula can I use to return the earliest Date from the Date Column for a given Name?
Thanks.

Paul Newcome

You would use a MIN/COLLECT combo.

=MIN(COLLECT([Date Column:[Date Column], [Name Column]:[Name Column], @cell = "John Smith"))