I have 2 spreadsheets. In spreadsheet A I have a column of e-mail addresses
500 names long. In spreadsheet B, I have these same e-mail addresses plus
800 more all randomly listed in a column. I want to sort the long B list
such that the e-mails that match the short A list are noted or the
non-matches are deleted or whatever is appropriate.
I'm using Excel for the Mac v X