Detect date/time collisions with multiple criteria

[macfoo]

I have data that I am trying to determine where date/time overlap (TRUE/FALSE) works but only when certain criteria are met.
The collision column is what I'd like to do via formula or macro...

I'm able to find collisions using SUMPRODUCT (found plenty of examples) until I start adding criteria, but that won't work since I need to find date/time collisions only when address and identifier are the same.


Example below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Address[/TD]
[TD]State[/TD]
[TD]Identifier[/TD]
[TD]Collion?[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]09/26/2018 09:00[/TD]
[TD]09/26/2018 12:00[/TD]
[TD]Boxwood[/TD]
[TD]TN[/TD]
[TD]7212[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]09/26/2018 09:00[/TD]
[TD]09/26/2018 12:00[/TD]
[TD]Norfolk[/TD]
[TD]VA[/TD]
[TD]9713[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]1265[/TD]
[TD]09/26/2018 10:00[/TD]
[TD]09/26/2018 16:00[/TD]
[TD]Norfolk [/TD]
[TD]VA[/TD]
[TD]9713[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]1265[/TD]
[TD]09/26/2018 10:00[/TD]
[TD]09/26/2018 16:00[/TD]
[TD]Somewhere[/TD]
[TD]MN[/TD]
[TD]1897[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]1279[/TD]
[TD]09/28/2018 02:00[/TD]
[TD]09/28/2018 14:00[/TD]
[TD]Smith[/TD]
[TD]TX[/TD]
[TD]7212[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]1298[/TD]
[TD]09/26/2018 04:00[/TD]
[TD]09/29/2018 02:00[/TD]
[TD]Sasquatch[/TD]
[TD]AK[/TD]
[TD]1897[/TD]
[TD]NO[/TD]
[/TR]
</tbody>[/TABLE]