Results 1 to 2 of 2

Thread: How to divide two different columns data in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    How to divide two different columns data in Excel

    I'm trying to divide one column by another column to give me another column of answer as in B1/C1=D1, B2/C2=D2 etc. Is this possible? If yes then how can I make this thing happen in Excel? If you guys have any ideas to divide column(x) by column(y) to give column(x/y) in excel then please do the reply. Any of the suggestion is appreciated and thanks.

  2. #2
    Join Date
    Jun 2011
    Posts
    492

    Re: How to divide two different columns data in Excel

    This is simple to make the division of different data in Excel, so for that you just have to make the use of these steps. In cell D1 enter the following formula: =B1/C1, and after that Copy this formula down column D as far as you need. The cell references will increment automatically. May this will help you out.

Similar Threads

  1. how to match data between 2 columns in excel
    By dankar in forum Windows Software
    Replies: 1
    Last Post: 25-04-2013, 11:16 AM
  2. [VBS] Change data in columns in CSV
    By Conus in forum Software Development
    Replies: 1
    Last Post: 30-04-2012, 11:18 PM
  3. How to divide the collection of data at once in Excel
    By Rao's in forum Windows Software
    Replies: 1
    Last Post: 14-01-2012, 11:46 AM
  4. How to swap data between columns and rows in Excel
    By Rao's in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 04:46 PM
  5. How to find percentage of columns data in Excel
    By Kungfu Pandey in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 05:20 PM

Posting Permissions

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