compare two columns in excel 2011 for duplicates mac

Compare Two Columns In Excel 2011 For Duplicates Skin The Cat

Column A is a list of email addresses for people I have already written.

Column B is a list of email addresses for people I would like to contact.

I am not sure if there are email address from Column A in Column B, but there may be and if there are, I must find out so that I dont send a second email to these recipients.

How can I have Numbers look at both columns and tell me which email addresses in Column B are not in Column A Thanks for the help.

I hope you find one of the two solutions, Waynes or this one, useful for your case.

Compare Two Columns In Excel 2011 For Duplicates Skin The Cat

As always with computers, there are always several ways to skin the cat.

The solution may depend on severl factors one of which is how often will you perform the task If not very hard then the solution need only be good enough to solve the immediate problem.

Post back if you need more help with this, or other, problems.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.

Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.

All postings and use of the content on this site are subject to the.

Compare Two Columns In Excel 2011 For Duplicates Mac