If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count and Sum Total occurrances of two specific numbers | Sam via OfficeKB.com | Worksheet Functions | 10 | March 29th, 2005 08:13 PM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
COUNT /COUNTIF for Multiple Column Defined Dynamic Named Range | Tinä | General Discussion | 1 | October 26th, 2004 01:36 AM |
How do I count a range of numbers in a column | SLB | General Discussion | 3 | October 21st, 2004 05:23 PM |
adding values from another worksheet by matching criteria | Frank Kabel | Worksheet Functions | 2 | March 16th, 2004 04:15 PM |