My goal is to isolate the ID#s observed in Zone C and only Zone C (like IDs 2236 and 3007 in the attached table). There are records for which the same ID was observed in other zones besides Zone C, or was observed multiple times in Zone C.
How can I extract only those individuals who were observed in C and ONLY in C? Selecting by location is not what I need because some of the ID#s in C are also in other zones. I have tried Select by Attribute and the Dissolve tool but I am not quite getting the right combination. Can someone point me in the right direction? I am using ArcGIS Desktop 10.4.