Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to divide two different columns data in Excel

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 08-01-2012
Member
 
Join Date: Jun 2011
Posts: 486
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to divide two different columns data in Excel"
Thread Thread Starter Forum Replies Last Post
how to match data between 2 columns in excel dankar Windows Software 1 25-04-2013 11:16 AM
[VBS] Change data in columns in CSV Conus Software Development 1 30-04-2012 11:18 PM
How to divide the collection of data at once in Excel Rao's Windows Software 1 14-01-2012 11:46 AM
How to swap data between columns and rows in Excel Rao's Microsoft Project 1 08-01-2012 04:46 PM
How to find percentage of columns data in Excel Kungfu Pandey Windows Software 2 07-01-2012 05:20 PM


All times are GMT +5.5. The time now is 02:42 PM.