Thanks, Ron. After replying to the above response, I decided to replace my
list with the new one but this article will come in very handy for some
other things on my To Do pile.

Linda
"Ron de Bruin" wrote in message
...
Hi Linda

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"LMB" wrote in message
...
If I have a list of names (Last in one column, First in another) and fax
numbers can excel compare and update or flag the numbers that changed or
names who are not on the on the first list and also flag new names?

Excel 2000 but could use 2003.

Thanks,
Linda