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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Station[/TD]
[TD]Start Time[/TD]
[TD]Result[/TD]
[TD]Tagged[/TD]
[/TR]
[TR]
[TD]39576[/TD]
[TD]T014[/TD]
[TD]10/27/2017 11:59[/TD]
[TD]Fail[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]39576[/TD]
[TD]T014[/TD]
[TD]10/27/2017 12:22[/TD]
[TD]Pass[/TD]
[TD]Tag[/TD]
[/TR]
[TR]
[TD]39576[/TD]
[TD]T014[/TD]
[TD]10/27/2017 14:41[/TD]
[TD]Pass[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]39576[/TD]
[TD]T011[/TD]
[TD]10/27/2017 14:58[/TD]
[TD]Pass[/TD]
[TD]Tag[/TD]
[/TR]
[TR]
[TD]39576[/TD]
[TD]T011[/TD]
[TD]10/27/2017 15:11[/TD]
[TD]Pass[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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