Need help on duplicates
Hello!
I need help on removing duplicates. I have a typical spreadsheet with company name, first name, last name, address, zip code and etc. I also have two columns that show who received a marketing email from my company with an X. I need to somehow remove all duplicate emails but make sure that when I remove the duplicate emails, the X next to the name does not get removed. I need to remove the duplicates but keep one of the two duplicates that has the X marked next to it.
Thank you!!
Shaina
Hello shainadahlitz,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks