Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have four Excel files that contain email addresses. I need to find out how many unique addresses are in the first three, but not in the fourth.

What's the easiest way to do that?

share|improve this question
up vote 2 down vote accepted

If you can copy all of the data into one sheet, you can use the 'remove duplicates' (under Data) to find unique addresses. If you colour-code the entries from each file first, you'll be able to tell which came from where, and which ones are left over.


If you used background colours to code the entries, you can use this function to count the entries.

If you coloured the font, you can use this function, taking care to replace 'Interior' with 'Font' as noted in the explanation at the top.

share|improve this answer
Thanks. That takes care of the "merge" part. Is there a way to find out how many entries have a certain color? Can I sort by color? – Patrick McElhaney Jul 16 '09 at 20:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .