- Need Help Finding Duplicate Customers

[mary wei]

Hello Everyone,

I have two customer lists with a names and customer numbers. They are
currenlty in the same spreadsheet. I'd like to create a list of
duplicate customers who have the same customer number. One list has
over 10,000 customers. The other list only has a few hundred.

How do I find the duplicates and create a separate list of only the
duplicate customers with the same customer number?

Thanks so much!

 

[JE McGimpsey]

Take a look here:

http://cpearson.com/excel/duplicat.htm