View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gssjp6423 Gssjp6423 is offline
external usenet poster
 
Posts: 1
Default Compare cells in column A ("ID") to column A ("ID)in two differen.

My excel workbook has two worksheets with headcount data for Oct and Nov
2006.. I would like to compare the column that consist of the identifier "ID"
in both worksheet. If the "ID" do not match, then display the content from
that row. If the "ID" do match but the contents in the row is different,
then display the content from that row. If the "ID" do match and the
contents in the row are the same, then do not display the content from that
row.