Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add 1 count to a column of numbers
If I have a column of numbers and I want to increase each number in that
column by 1, how do I do that? THANX!! |
#2
|
|||
|
|||
put the number 1 in an empty cell
copy that cell select the list of numbers and use Edit-Paste Special-Add "JeriSys" wrote: If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!! |
#3
|
|||
|
|||
simplest way is to enter 1 inot an empty cell. copy that cell select tge
column and paste special -add "JeriSys" wrote: If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!! |
#4
|
|||
|
|||
Thanks!!
"Duke Carey" wrote: put the number 1 in an empty cell copy that cell select the list of numbers and use Edit-Paste Special-Add "JeriSys" wrote: If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!! |
#5
|
|||
|
|||
Thanks!!!
"bj" wrote: simplest way is to enter 1 inot an empty cell. copy that cell select tge column and paste special -add "JeriSys" wrote: If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add 1 count to a column of numbers
Thank you so much for this. I've been struggling with this and you made it
so simple. This is the answer to a question I keep asking folks. Thx a million "JeriSys" wrote: Thanks!!! "bj" wrote: simplest way is to enter 1 inot an empty cell. copy that cell select tge column and paste special -add "JeriSys" wrote: If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
formulas to numbers | New Users to Excel | |||
Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) | |||
Count based on another column | Excel Discussion (Misc queries) | |||
COUNT IF COLUMN X="" COUNT COLUMN Y? | Excel Discussion (Misc queries) |