View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alant
 
Posts: n/a
Default Comparing columns from 2 different worksheets.

I have 2 worksheets. I need to compare the cells in column1/worksheet1 to
the cells in column1/worksheet2. If a cell in column1/worksheet1 is nowhere
in column1/worksheet2, then I want to display the missing cells in
column1/worksheet3 along with the corresponding column2 cells from
worksheet1. Note: worksheet 2 has many more rows than worksheet1.
Thanks