# Thread: How to normalize a data formula in Microsoft Excel

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

2. Member
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. Member
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.

#### Posting Permissions

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