How do I identify duplicates (in one column relative to another)?
Posted by Scott on July 13, 2001 6:52 AM
SITUATION: I have a column of account names (text) with approximately 3000 rows. I would like to compare column with another column, and identify (i.e. flag) those account names that exist in both columns (duplicates).
QUESTION: How do I get Excel to identify (preferably by highlighting) those entries that are listed in BOTH column #1 AND column #2?
NOTE: The columns do not share the same case (Column #1 is a mixture of small-caps and large-caps, while Column #2 is all capital letters) - does this matter?