• 0

EXCEL - Rows into Individual Cells


Question

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

  • 0
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

  • 0

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

  • 0

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.