Hello
I'm a newbie of excell and have a simple question...
Lets say I have/fill columns A and B with integers and I want to by automation calculate the difference B-A how do I do that.....I know how I do for one row but I wants a formula like B[i]-A[i]=C[i] where i is the current row so I dont have to do it every time I put some values in column A and B
Thanks in advance!
Best regards/D_D
Hi,
You could do this with a one step formula, or with a macro. Let's look at both options..
Formula:
Select the range in C adjacent to the data in column B and A.
With C1 as the activecell, enter ..
=B1-A1
Confirm with Ctrl + Enter.
Macro:
To run the macro routine, copy the above code --> press Alt + F11 (to open the Visual Basic Editor or VBE) --> Insert --> Module --> paste on right.
Please Login or Register to view this content.
HTH
Regards,
Zack Barresse
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks