Hi

check out Chip Pearson's website
http://www.cpearson.com/excel/duplicat.htm

right down the bottom of the page are two articles - "Extracting values
common to two lists" and "Extracting values on one list and not on
another" - which i think will give you what you need.

Cheers
JulieD

"mf4852" wrote in message
...
Office 2003 - I need to compare two worksheets and get results on a third
and
fourth. Worksheet1 is channel list 1, worksheet2 is channel list 2,
worksheet3 would be the channels that they have in common while worksheet
4
would be the channels that they don't have in common.