Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BayComp
 
Posts: n/a
Default increase all values in a column by a percentage

How di i change the value of all data in a column by a given percentage? e.g
i want to increase an entire columns entered values by a percentage i choose.


TIA
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BayComp" wrote in message
...
How di i change the value of all data in a column by a given percentage?
e.g
i want to increase an entire columns entered values by a percentage i
choose.


TIA



  #3   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"BayComp" wrote in message
...
How di i change the value of all data in a column by a given percentage?

e.g
i want to increase an entire columns entered values by a percentage i

choose.


TIA


Snipped from http://www.j-walk.com/ss/excel/usertips/tip059.htm


1.. Enter 1.05 (percentage) into any blank cell.
2.. Select the cell and choose Edit, Copy.
3.. Select the range of values and choose Edit, Paste Special.
4.. Choose the Multiply option and click OK.
5.. Delete the cell that contains the 1.05.
/Fredrik


  #4   Report Post  
BayComp
 
Posts: n/a
Default

Neik , fredrik , a million thanks guys :), works perfect



"Niek Otten" wrote:

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BayComp" wrote in message
...
How di i change the value of all data in a column by a given percentage?
e.g
i want to increase an entire columns entered values by a percentage i
choose.


TIA




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Chart with 2 values in each column Alec Green Charts and Charting in Excel 2 February 25th 05 07:12 AM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 03:44 AM
How sum values in column B using values in column A as the conditi oldgrayelf Excel Worksheet Functions 5 February 4th 05 10:03 PM
Removing duplicate values in a column natan Excel Worksheet Functions 2 November 22nd 04 07:48 AM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 03:09 PM


All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"