# Finding All First of Sequence in a Table

#### Innoguide

##### Board Regular
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

 A B C 1 Event Date First in Sequence 2 F1-123 1/2/2019 3 F1-123 1/7/2019 4 F1-123 1/7/2019 5 F1-123 1/1/2019 6 F7-125 2/1/2019 7 F7-125 2/5/2019 8 F7-125 2/7/2019 9 F7-125 1/15/2019 First 10 F7-125 2/1/2019 11 R2-123445 3/1/2019 First 12 R2-123445 3/15/2019 13 R2-123445 3/12/2019 14 F7-125 3/15/2019 15 F1-123 12/25/2018 First

<tbody>
</tbody>

Last edited:

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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.

Thanks Marcelo - That worked perfectly!

You're welcome. Thanks for the feedback.

M.

Replies
6
Views
422
Replies
3
Views
174
Replies
9
Views
291
Replies
5
Views
142
Replies
14
Views
1K

1,203,683
Messages
6,056,730
Members
444,887
Latest member
cvcc_wt

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back