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 -