How do you compare data in two columns for duplicates?

Answer by  technogeek (6640)

You would have to use a vlookup formula to find duplicates in two columns. You can go to Microsoft's website to find out how to write the formula.

Answer by  gyles19 (126)

The process depends upon the tools available. The basic logic is to sort the two columns, and then loop through them, comparing the two values, When the value in a column is less than the value of the other, increment through that column until the value is equal or greater. Then switch to the other column. Take action for matches.

Answer by  runnerG12 (124)

A simple heuristic to this manually is to sort both columns in alphabetic or numeric order and then compare the numbers top down.