Hello everyone. I work at an airport and could use some help.


I would like to compare some columns of names. There are over 100,000.

So far I have used the MATCH function but it only gives me the first match and then stops. How can I get the references of all the matches that might exist? Also I cannot figure out how to stop MATCH from matching the name from the line itself. In other words the cell that I use to reference the name value is matching itself.

Any suggestions for a start? I am sure there has to be some advanced programs for this kind of thing. I am sure you guys need more than what I have provided and I will give whatever you need.

I'll take whatever you have.