View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Find missing data

I exported some information from access based on two queries. I want to
check what data is missing out of one report as opposed to the other. How
can I do a look up that tells me - MFG #, MANUFACTURER, DESCRIPTION, UNIT
PRICE, Sum of Quantity, & Sum of Amount on spreadsheet 2006-01, sheet
Discrepancies match same on the spreadsheet qThree, sheet qThree? That way I
can see which records are on the qThree spreadsheet that did not appear on
the Discrepancies spreadsheet. Thank you very much for your help!!! I
really appreciate it :o).