View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default how do I analyse two spreadsheets for missing data?

One way to do this is to determine a data point on each row that is
common to both spreadsheets. It may be a customer name, account
number, something like that. Then use a COUNTIF formula that counts
the occurences of that data point on the other spreadsheet. Any zeroes
that result from the COUNTIF are missing on the other spreadsheet.

Impress your boss: perform this operation on *both* sheets to make sure
you have captured all the data.