LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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).
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 07:52 PM
Despite data existing in Excel 2002 spreadsheet Find doesn't find AnnieB Excel Discussion (Misc queries) 1 June 16th 06 02:15 AM
Numbers/Text data missing from excel to excel query? RAMAERTE Excel Discussion (Misc queries) 0 May 8th 06 05:05 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"