MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Identifying Duplicates


Posted by Scott on July 10, 2001 1:02 PM

I have a column of account names (text) with approx. 3000 rows. I would like to compare column with another column, however it should be noted that 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) - I don't know if this makes a difference.

How do I get Excel to identify the duplicates, and then hide them (to leave Column #1 with only those accounts that are not duplicates)?

I am not an Excel wizard, so if you can help, please give me solid instructions! Thanks in advance -


Posted by thomas venn on July 10, 2001 2:19 PM

Hello,

Try vlookup or index(...match(...)) . There is a wizard which guides you through vlookup. give it a try. another tedious method might be try sorting the two columns.
cheers,

thomas