View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
Andy Andy is offline
external usenet poster
 
Posts: 5
Default Comparing columns

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