LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Excel - Comparison Help

I have a sheet with raw data - from which a pivot table was created for us.
It contains values as such:

Location ID Type of Hardware Number of Units

In a separate sheet, I have location id and number of units.

I want to create a new sheet that compares the location ids in both sheets
and then tell me when there is a discrepency in the number of units.

Help?

 
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
How to do Pairwise comparison in Excel Phillip Excel Worksheet Functions 3 April 3rd 23 03:42 PM
Excel 97 - Comparison Jerim79 Excel Discussion (Misc queries) 6 March 16th 07 06:41 PM
Excel Comparison program? Ben Excel Discussion (Misc queries) 2 December 11th 06 08:29 PM
Excel - date comparison stormsailor Excel Discussion (Misc queries) 2 July 19th 05 05:46 AM
Copy data between 2 Excel for comparison Boba Excel Discussion (Misc queries) 1 February 18th 05 12:56 AM


All times are GMT +1. The time now is 11:44 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"