Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment column values
Hi, I know there's a procedure to increment the values in a column by
1, where the result is a column with cells 1,2,3,4,5, etc. but what I'm looking for is a way to increment whatever value is in a cell by a given number. For instance, for the values .5,3,5.5, 4 you'd get values 1.5,4,6.5,5 I'd appreciate any help supplied. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment column values
Try this:
type the number you want to increment by in a cell. Go to Edit-Copy. Highlight the range of cells you want to increment. Go to Edit - Paste Special - Add and hit OK. On Sep 5, 8:40 am, wrote: Hi, I know there's a procedure to increment the values in a column by 1, where the result is a column with cells 1,2,3,4,5, etc. but what I'm looking for is a way to increment whatever value is in a cell by a given number. For instance, for the values .5,3,5.5, 4 you'd get values 1.5,4,6.5,5 I'd appreciate any help supplied. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment column values
On Sep 5, 7:50 am, Tim879 wrote:
Try this: type the number you want toincrementby in a cell. Go to Edit-Copy. Highlight the range of cells you want toincrement. Go to Edit - Paste Special - Add and hit OK. On Sep 5, 8:40 am, wrote: Hi, I know there's a procedure toincrementthevaluesin acolumnby 1, where the result is acolumnwith cells 1,2,3,4,5, etc. but what I'm looking for is a way toincrementwhatever value is in a cell by a given number. For instance, for thevalues.5,3,5.5, 4 you'd get values 1.5,4,6.5,5 I'd appreciate any help supplied. Thanks.- Hide quoted text - - Show quoted text - Thanks, I'll try that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment column on drag down | Excel Discussion (Misc queries) | |||
Auto-increment cell values by one | Excel Worksheet Functions | |||
Increment numbers in a column | Excel Discussion (Misc queries) | |||
increment a column based on information in another column | New Users to Excel | |||
How do I increment or decrement values in a column? | New Users to Excel |