I am in desperate need of help - I have a list of names and addresses, 26,176 rows to be exact. Some of the entries (names) appear on the list twice. I need to find the duplicates, and then delete BOTH of the duplicates - not just one. I am basically preparing a list of marketing prospects. I took a list of our current customers, and merged it with a list of prospects. Within that list of prospects, some of our current customers are already in there. So the end result I need is a list with ALL of our customers omitted, so that I'm left with just a pure suspect list. HELP!! I'm ready to tear my hair out.
Bookmarks