Finding Duplicates in Excel
June 12, 2009 7:44 AM Subscribe
I need an Excel conditional formatting formula for locating dups within a two-column row.
posted by RavinDave to Computers & Internet (3 answers total) 2 users marked this as a favorite
Okay, I have a spreadsheet with two columns (A & B)
A = 1,500 Traditional hanzi
B = 1,500 Simplified hanzi
About 80% of the time, A = B. Sometimes, the Simplified is different than the Traditional. Sometimes, it's wildly different. I'm not worried about those -- I can spot them easily enough. But sometimes, the difference is VERY subtle.
Thus, I need an Excel formula that will compare the two and (maybe) change the background color of Column 2 if it is different than Column 1.