find duplicate cells then subtract corresponding cells.

Microsoft Office 2011 for mac home and s...
December 16, 2011 at 10:53:59
Specs: Mac OSX 10.7
I have 2 sheets. I need to compare economos numbers (but one list has duplicates in it that cannot disappear). If the 2 sheets have the same economos number, then I need to be able to take the price of each number (the prices are from different points of time) and subtract them to calculate the difference. How can i do this?

See More: find duplicate cells then subtract corresponding cells.

December 16, 2011 at 11:05:52
You will need to supply some more details before we can offer any solutions.

Keep in mind that we can't see your spreadsheets from where we're sitting, so you need to tell us in what columns/rows the values are located, what ranges need to be subtracted, etc.

Posting some example data might help a lot.

Before you post any example data, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question