I am trying to check whether a certain datapoint exists in multiple locations.

This is what my table looks like:

I am checking whether the same datapoint is in two locations. The idea is that this datapoint should exist in BOTH locations, and be counted only once if it is flagged in both. The end result should look like this:

Thanks in advance