I have a dataset of plants, they are many different plant species that are given a numerical code in a column in the attribute table, but they are located in different land types which was also identified in another column , I want to make a selection that highlights the plant (or points) that share the same species ID but are located in different land types. Here is an example:
I want to know if there is a tool that I can use to select the points with OID 2, 3, 7, 8, and 9 since they are grouped by plant species but there is at least one point (i.e. plant) located in different land Types than all the other points that share the same Species ID. I am using ArcMap 10.2.1.
Quick note: there is no map or layer for the Land Type field.