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 ???

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.

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 116114I 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 ???

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.

Thanks a lot ... That worked :)

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History