Compare Text
One more option for you. In Excel 2007, you can select both columns, go to
Conditional Formatting, Highlight Cells Rules, and choose Duplicate Values.
It will fill cells with duplicate values with color.
"Toria" wrote:
Hello,
I have two columns of names, DO and DQ. I need to know when there's a match
without going row by row and maunally eyeballing it. I've spent all morning
trying to figure out. Any help is much appreciated.
Thank you.
|