Results 1 to 5 of 5

divide a column by another column

This is a discussion on divide a column by another column within the Excel Questions forums, part of the Question Forums category; I'm trying to create a formula to allow me to take column B and divide by column C. I need ...

  1. #1
    New Member
    Join Date
    Sep 2003
    Posts
    2

    Default divide a column by another column

    I'm trying to create a formula to allow me to take column B and divide by column C. I need to have the answers by each row, and can't find a way other than going by each row invidually. If this is possible please help. I have 3 worksheets with over 11,000 rows each and doing them individually will break my heart!

  2. #2
    Board Regular
    Join Date
    Jun 2002
    Posts
    546

    Default Re: divide a column by another column

    If I understand correctly, you simply want to divide one a cell in one column by a cell in another and duplicate down the sheet. =B1/C1. Then use the auto fill function. Move the mouse to the lower right hand corner of the result cell where the small box is, and drag the formula down the page. (or just double click) Unless I misunderstood what you wanted, it is as simple as that. Good Luck

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,253

    Default Re: divide a column by another column

    Quote Originally Posted by workingrl
    I'm trying to create a formula to allow me to take column B and divide by column C. I need to have the answers by each row, and can't find a way other than going by each row invidually. If this is possible please help. I have 3 worksheets with over 11,000 rows each and doing them individually will break my heart!
    You want to sum coulmn B and divide by the sum of column C? What do you mean 11000 rows if you're dividing columns?

  4. #4
    New Member
    Join Date
    Sep 2003
    Posts
    2

    Default

    Thanks gnrboyd, that's exactly what I needed!

  5. #5
    Board Regular
    Join Date
    Jun 2002
    Posts
    546

    Default Re: divide a column by another column

    No problem. Glad to help.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com