Mint Tea Posted March 6, 2012 Share Posted March 6, 2012 Hi all, I have two columns (A & B) of about 50 entries. (1) Is there a way to subtract up all the contents of row 2 from row 1 into separate cells in Column C? That is, without typing =B-A1, =B2-B2 .... into each individual cell in column C? (2) Separate question: I have three columns (A B C) of 50 entries. Same as above, any way to separate into individual cells if I want to do something like =IF(A1=B1, C1-B1) .... for each individual cell. Thanks, Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted March 6, 2012 Supervisor Share Posted March 6, 2012 That is, without typing =B-A1, =B2-B2 .... into each individual cell in column C? If you mean to propagate an operation down the column, type =B1-A1 into C1 and hit Enter. Then click C1 and drag the little square in the corner down to the last set of numbers you want to subtract, and the values will automatically be filled in. Link to comment Share on other sites More sharing options...
0 AbandonedTrolley Posted March 6, 2012 Share Posted March 6, 2012 Yup as mentioned above just do it once and then use the handle in the bottom right of the cell and drag down. Else you can double click the handle to fill in as well. Link to comment Share on other sites More sharing options...
0 Mint Tea Posted March 6, 2012 Author Share Posted March 6, 2012 Fantastic - Thank you. I don't know why I couldn't remember how to do this...guess I'm just tired. Thank you both for the input. I appreciate it. Link to comment Share on other sites More sharing options...
Question
Mint Tea
Hi all,
I have two columns (A & B) of about 50 entries.
(1) Is there a way to subtract up all the contents of row 2 from row 1 into separate cells in Column C?
That is, without typing =B-A1, =B2-B2 .... into each individual cell in column C?
(2) Separate question: I have three columns (A B C) of 50 entries.
Same as above, any way to separate into individual cells if I want to do something like =IF(A1=B1, C1-B1) .... for each individual cell.
Thanks,
Link to comment
Share on other sites
3 answers to this question
Recommended Posts