Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
1. Key 25 and 1 in 2 open cells.
2. Copy the cell with 25. 3. Select the range of data to update 4. Go to Edit Paste Special. Select "Divide". OK 2. Copy the cell with 1. 3. Select the range of data to update 4. Go to Edit Paste Special. Select "Add". OK HTH Jason Atlanta, GA -----Original Message----- I have a quick question for anyone who can help. I have a large data set that I need to convert. To explain this I have three columns with 450 data points in each. In one of the columns I need to change each data entry by the same amount. (x+25)/25. I am wondering if there is a way to have excel change each point by that amount, rather than doing it by hand. -Thanks in advance for the help . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) | |||
Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
How do I return an entire row of data from a reference array? | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
formula to determine the first column containing any data | Excel Worksheet Functions |