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:

#	Start	End	Address	State	Identifier	Collion?
1234	09/26/2018 09:00	09/26/2018 12:00	Boxwood	TN	7212	NO
1234	09/26/2018 09:00	09/26/2018 12:00	Norfolk	VA	9713	YES
1265	09/26/2018 10:00	09/26/2018 16:00	Norfolk	VA	9713	YES
1265	09/26/2018 10:00	09/26/2018 16:00	Somewhere	MN	1897	YES
1279	09/28/2018 02:00	09/28/2018 14:00	Smith	TX	7212	NO
1298	09/26/2018 04:00	09/29/2018 02:00	Sasquatch	AK	1897	NO

<tbody>
</tbody>