B barry Oct 17, 2003 #1 I have two excel files with phone numbers. How do I sort to make sure there are no duplicates between the lists?
I have two excel files with phone numbers. How do I sort to make sure there are no duplicates between the lists?
D Dave Peterson Oct 18, 2003 #2 Chip Pearson has a bunch of techniques for dealing with duplicates at: http://www.cpearson.com/excel/duplicat.htm
Chip Pearson has a bunch of techniques for dealing with duplicates at: http://www.cpearson.com/excel/duplicat.htm
M Martin Lam Oct 18, 2003 #3 Hi Barry, In Excel 2000: "Data"-->"Filter"-->"Advanced Filter", remember to tick "unique records only". Martin Lam
Hi Barry, In Excel 2000: "Data"-->"Filter"-->"Advanced Filter", remember to tick "unique records only". Martin Lam
