Easiest way to remove duplicate items or compare lists

[Ben]

I have recently purchased the assets of a failing company. Now I have a
bunch of customer lists in several different varieties. Most of the lists
are in paper format some customers are in the database as well. I am
considering using excel to sort out what customers were duplicated the
lists. What's the best way to get the duplicates sorted through, Apple
script or Macro's? Are there examples laying around anywhere?

 

[J.E. McGimpsey]

I have recently purchased the assets of a failing company. Now I have a
bunch of customer lists in several different varieties. Most of the lists
are in paper format some customers are in the database as well. I am
considering using excel to sort out what customers were duplicated the
lists. What's the best way to get the duplicates sorted through, Apple
script or Macro's? Are there examples laying around anywhere?

Take a look at Chip Pearson's page:

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

Also, you may be interested in adapting my macro to scrub a mailing
list:

http://www.mcgimpsey.com/excel/scrublist.xhtml