Compare to find duplicates within worksheet
Posted by Tracy Janecek on May 16, 2001 4:33 AM
I hope one of you gurus can help me with this one. I have a contact list that stretches across 12 or so columns listing contact first name, last name, title, company, address, mail stop, city, state,....ect
Is there an easy way to do a comparison of the entries within each column searching for same text? I would like to search on the company column first and if no matches are found to search address then phone number and so on and so on.
Not knowing enough to do this myself(still learning), what would be the best way to show the duplicates from within the search? Do you have them filled with color or copied to a second sheet?
I appreciate all of your assistance!