Results 1 to 3 of 3

Thread: How to normalize a data formula in Microsoft Excel

  1. #1
    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    638

    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

  3. #3
    Join Date
    Jul 2011
    Posts
    642

    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.

Similar Threads

  1. How to normalize Excel data in Excel Rows
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:20 PM
  2. Replies: 2
    Last Post: 23-02-2012, 03:57 PM
  3. How to put formula in Text Box in Microsoft Excel
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 04:58 PM
  4. Convert copy formula to Text in Microsoft Excel
    By Kaesav in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 06:39 PM
  5. Formula for tracking annual leave in Microsoft Excel
    By Kungfu Pandey in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 04:29 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
  •