In Excel 2001 on MAC OX S-I have a list of 49,000 names, most are duplicates after merging numerous mailing lists. Need to eliminate the duplicate entries and have only unique names for mailing. Finding lots of information to use the 'remove duplicates' button, but I can't find it anywhere. Where is it? And if I don't have one, how do I accomplish this task short of hand deleting line by line.
Bookmarks