Finding All First of Sequence in a Table

[Innoguide]

I have a table of dates (column B) associated with event Identifiers (Column A) and need a formula in column C that will find the first date for each event as shown in the table below.

I've been playing with Index-Match and know that if the row is the min of all the rows where the event is the same as that row, then the result should be "First" otherwise "" but am struggling to get the correct formula
Here is what I was trying but am missing something
=IF(b2=MIN(INDEX(b$2:b$15,MATCH(a2,a$2:a$15))),"First","")

Any suggestions for a formula would be greatly appreciated

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Event[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]First in Sequence[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]F1-123[/TD]
[TD="align: center"]1/2/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]F1-123[/TD]
[TD="align: center"]1/7/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]F1-123[/TD]
[TD="align: center"]1/7/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]F1-123[/TD]
[TD="align: center"]1/1/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]2/1/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]2/5/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]2/7/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]1/15/2019[/TD]
[TD="align: center"]First[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]2/1/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]R2-123445[/TD]
[TD="align: center"]3/1/2019[/TD]
[TD="align: center"]First[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]R2-123445[/TD]
[TD="align: center"]3/15/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]R2-123445[/TD]
[TD="align: center"]3/12/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]F7-125[/TD]
[TD="align: center"]3/15/2019[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]F1-123[/TD]
[TD="align: center"]12/25/2018[/TD]
[TD="align: center"]First[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Array formula in C2 copied down
=IF(B2=MIN(IF(A$2:A$15=A2,B$2:B$15)),"First","")
confirmed with Ctrl+Shift+Enter, not just Enter

M.

 

[Innoguide]

Thanks Marcelo - That worked perfectly!

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

M.