Hi Andy,

See Chip Pearson's Duplicates and Unique Values page.

http://www.cpearson.com/excel/duplic...tingDuplicates

Look in particular at the last two sections on that page.


---
Regards,
Norman



"Andy" wrote in message
.co.uk...
Hi,

Can somebody please advise me on how to do the following in Excel:

Compare a set of values (text) in column A with a set of values (text) in
column B (no necessarily in line with each other) and output any
differences
to any of the following:
- Column C
- Another worksheet in the same workbook
- a text file

Thanks

Andy