find earliest start date per person formula/function question

Hello,

I have two columns of data. One contains a list of people and the other contains a list of dates in the date format. There are many dates per person. Does anyone know of a formula I could use to identify in a third column what is the earliest date per person in the table? I have an attached an example. Any help would be much appreciated.

example pic.PNG

Try this in C2:

=IF(B2=MIN(IF($A$2:$A$100=A2,$B$2:$B$100)),"earliest","")

Array formula, enter with Ctrl+Shift+Enter.

It works! Thanks so much!

Thank you!

For you, a formula without massive input

Formula:

Please Login or Register  to view this content.