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 l