Column A lists a type of label, B lists the individuals identification number.
Column G is the latitude, Column H is the longitude.

I need to see data when the same individual was found at different locations. So When Column A and B match between the rows, but the location (G&H, lat&long) are different between rows. I need all the data where the same individual was found at 2-6+ locations.

I did filter my data set to remove duplicate entries but because data from the initial access query were pulled from multiple databases with slightly different formats occasionally a row is just a duplicate entry of the row above, but was not erased because a descriptive field (ie: column E, habitat description) was filled out slightly differently in a different database.

Example:

Column A- Type..........Column B- ID #.........Column C- Species......Column D- Capture Date....Column G-lat........Column H- long
Alumninum.....................A1142..............................MYC...................1/2/1998...............37.359232..................-81.34343
Alumninum.....................A1142..............................MYC...................1/2/2010...............36.232951...................-81.35332
Plastic..........................A1142..............................MYC ..................8/2/2000...............37.232951...................-83.35332
Alumninum.....................B0023..............................MYC...................6/3/1998...............37.359232...................-81.34343
Plastic..........................K0134 .............................PKR....................2/2/1999...............37.359232.................. -81.34343
Plastic..........................0134...............................THR....................1/2/2001...............39.359232...................-81.34343
Plastic..........................0134...............................THR....................1/2/2001...............39.359232...................-81.34343

In this example, I want just the first two rows, as this is the same individual captured at different locations. Sometimes an individual is captured the same night at different locations so I would need these data also.

Thank you very much for all the help in advance!