I have 2 list of phone numbers in 2 different workshhet.
How can I merge them in one list eliminating the repetitions
You could paste one below the other, and sort on phone number.
I'd expect you would want to examine the duplicates, so would include
a sequence number from top to bottom (constants) and include that
as your secondary sort field.
Then see Chip Pearson's page:(s) on Duplicates
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
others can be fround in his
http://www.cpearson.com/excel/topic.htm

Signature
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> I have 2 list of phone numbers in 2 different workshhet.
> How can I merge them in one list eliminating the repetitions