Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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.

Edit:

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.