ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Find missing data (https://www.excelbanter.com/excel-worksheet-functions/120458-find-missing-data.html)

DEE

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).


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com