LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default comparing data in excel

Using Excel 2003.

I have two columns for each month in a spreadsheet. Column A is the item
code and column B is the cost/item for last month. i then have in column C,
item codes and in column D cost/items for this month. Columns A and C do not
match entirely, because the same items may not have been touched each month.
Each may contain unique items, but some are common. I need to do the
follwing:

In column E, I need each row to look at what is in column C, see if it is
also in column A, and then show the decrease/increase of cost/item
(difference between columns B and D).

MARCH APRIL CHANGE IN COST
A B C D E
A134 $1 A043 $2 (SHOW NOTHING OR $0)
A558 $3 A134 $2 (SHOW +$1)
A6563 $2 A6563 $2 (SHOW $0)
A779 $2 A694 $4 (SHOW NOTHING OR $0)
A965 $8 A779 $1 (SHOW -$1)

I hope someone can help -- is making me crazy!
 
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
Comparing Data in Excel 2003 Diamonds_Mine Excel Worksheet Functions 7 June 21st 07 10:04 PM
Comparing two Excel data ranges for chnages... NWO Excel Discussion (Misc queries) 2 May 2nd 07 08:01 PM
Excel data comparing Ron Excel Worksheet Functions 0 October 12th 06 03:13 PM
Comparing Data from two excel sheets! Killer Excel Worksheet Functions 4 October 5th 06 08:57 AM
Comparing and moving unsorted data in Excel Kev427 Excel Discussion (Misc queries) 0 January 10th 06 04:20 PM


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

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

About Us

"It's about Microsoft Excel"