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

Sponsored Links



How to normalize a data formula in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-02-2012
Member
 
Join Date: Oct 2011
Posts: 74
How to normalize a data formula in Microsoft Excel

I am trying to normalize data sets in Excel to total 100%. I am wondering if there is a formula that can do this without having to correct each cell.

Reply With Quote
  #2  
Old 16-02-2012
Member
 
Join Date: Jul 2011
Posts: 610
Re: How to normalize a data formula in Microsoft Excel

Let's say the numbers are in G1:G20.
  • In some blank cell (say Z1) enter =SUM(G1:G20)
  • Copy Z1;keep Z1 the active cell and use Edit|Paste Special >Value
  • Copy Z1; select G1:G20 and use Edit > Paste Special > Divide. Your numbers no add to 1; format them % if you wish OR in step ! use =SUM(G1:G20)/100 and now you numbers all add to 100
Reply With Quote
  #3  
Old 16-02-2012
Member
 
Join Date: Jul 2011
Posts: 613
Re: How to normalize a data formula in Microsoft Excel

Hmmm, when I look at your values so, then it looks to me like, so if those already normalized, since they all lie between 0 and 1. Otherwise, you can easily apply your formula described in an auxiliary column and thus calculate the normalized data - by hand then you have to enter only the first formula and end up copying the entire column down. It exactly look like (it) as the data you plan to do so and how did you imagine the result.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to normalize a data formula in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to normalize Excel data in Excel Rows Hache hi MS Office Support 2 24-02-2012 06:20 PM
Need easy formula to calculate percentage in Microsoft Excel cupid! MS Office Support 2 23-02-2012 03:57 PM
How to put formula in Text Box in Microsoft Excel TheCarter MS Office Support 2 03-02-2012 04:58 PM
Convert copy formula to Text in Microsoft Excel Kaesav MS Office Support 2 01-02-2012 06:39 PM
Formula for tracking annual leave in Microsoft Excel Kungfu Pandey MS Office Support 1 14-01-2012 04:29 PM


All times are GMT +5.5. The time now is 07:20 AM.