Tag first instance of item based on criteria

[urkas]

I need to Tag the first instance based on Criteria

I need it to search a all instances and always Tag the first Match if the Item (39576 ) the Table T014 or T011) and if its Passed and Tag the first date of that pass

ID	Station	Start Time	Result	Tagged
39576	T014	10/27/2017 11:59	Fail
39576	T014	10/27/2017 12:22	Pass	Tag
39576	T014	10/27/2017 14:41	Pass
39576	T011	10/27/2017 14:58	Pass	Tag
39576	T011	10/27/2017 15:11	Pass

<tbody>
</tbody>

 

[mopp1]

Assuming ID is in A1

=IF((D2="Pass")*NOT(SUMPRODUCT((A$1:A1=A2)*(B$1:B1=B2)*(E$1:E1="Tag"))),"Tag","")

in E2 and drag down

 

[urkas]

Its not looking at date at all though ? C

I wish I could upload the sheet

 

[mopp1]

Assumption was that the dates for a particular ID/Station were in ascending order. If not then that formula will not work.

 

[urkas]

This did work though - So thanks for that