How to calculate difference of corresponding

December 23, 2010 at 21:12:54
Specs: Windows XP
I need to find the differences between two columns in the corresponding rows ... there are thousands of records ... is there any general method of doing this ???

See More: How to calculate difference of corresponding

Report •

#1
December 23, 2010 at 21:26:39
You need to be more specific regarding what you are trying to do.

Keep in mind that we can't see your spreadsheet from where we're sitting, so we have no idea what you have and therefore can not be of much assistance.

Posting a example subset of your data and the desired output based on the given examples always helps.

Please read the How To referenced in the following line before posting any data.

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


Report •

#2
December 23, 2010 at 21:46:39
Yup... I have records in the following manner

CTMTHWPROAR 232599 232586
CTMTHWPRIAR 248730 249449
CTMTSWPROAR 429532 429664
CTMTSWPRIAR 617728 617882
CTMTHWPROBR 123123 123106
CTMTHWPRIBR 135530 116114

I need to calculate the difference between columns B and C ... There are thousands of records like this ... Is there any general way in excel that i could do this ???


Report •

#3
December 23, 2010 at 22:26:06
Well, I don't see any column letters so I guess I'll just have to assume that Columns B and C are the ones with the numbers.

I also don't see any row numbers, so I guess I'll just have to assume that your data starts in Row 1.

"Calculate the difference" could mean many things, but I don't see any of the "desired output" that I asked for, so I guess I'll just have to assume that by "calculate the difference" you mean "subtract the values".

In D1 enter =B1-C1 or =C1-B1 and drag it down to the bottom of your list.

If your list is contiguous (no gaps) and you use the formula in an adjacent column (e.g. D), you can enter the formula in D1, put your cursor over of the autofill corner and double click. The formula should auto-fill down to bottom of your list.

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


Report •

Related Solutions

#4
December 23, 2010 at 23:23:19
Thanks a lot ... That worked :)

Report •

Ask Question