filtering and deleting dups

  • Thread starter Thread starter petevonna
  • Start date Start date
P

petevonna

Can I use one column of data (telephone numbers) in one
excel worksheet as a "filter" to find and delete
identical entries in another excel worksheet? Thank you.

Novice
 
Copy the 2 lists into one column (one above the other), give it a header,
select the header and the new list,
do data>filter>advanced filter, select copy to another location (just select
a cell anywhere on the help sheet)
and unique records only, click OK. Or take a look here

http://www.cpearson.com/excel/duplicat.htm
 
Back
Top