Greetings to all....

I have scoured this and other forums for help with my problem to no avail. Thanks in advance for your patience and help with this. I am a -newer- excel user and have been teaching myself overtime.

So, I have huge list of raw data parsed into excel from an XML file.The XML file is updated continuously. The data is formatted like this when i open it in Excel.

village name | x coordinate | y coordinate | points | player | clan



I filtered the data by clan, which then gives me the total list of villages from that clan. I did this twice with two different clans and copied each set into two different sheets. I want to compare Clan A's data with Clan B's data, and display any identical matches on a new sheet, or just know how many village matches there are. The way I have been trying to compare and match the data is by using the x , y columns because those are the village identifiers and they never change.

I am trying to make the most sense out of my problem. I thought you needed a little background about the information before moving on to help me. Thank you for your time and help.