# Formula for excel

Not open for further replies.

Joined:
May 6, 2002
Messages:
882

2. ### kiwiguy

Joined:
Aug 17, 2003
Messages:
17,584
Not really enough info, but:

put 1 in a spare cell. Click on that cell and Edit - Copy.

Then highlight all the numbers you want incremented by 1, and Edit - Paste Special - Add

You can delete the contents of the cell that you stored the 1 in, its not referenced.
Be careful though as this will increment all numbers including adding 1 to any formula.

3. ### wout

Joined:
Sep 9, 2003
Messages:
13
A B C D
1 25
2 =(A1+1)
3
4
5
COPY PASTE THE FORMULA TO A3 A4 A5 ETC

4. ### wout

Joined:
Sep 9, 2003
Messages:
13
. A B C D
1 25
2 =(A1+1)
3
4
5

COPY PASTRE THE FORMULA TO A3 , A4 ETC OR B2, B3 B4 ETC

5. ### itsmeagain

Joined:
Sep 26, 2003
Messages:
10
Highlight the start of the series along with the blank cells you wish to fill (in a row or column), then go to Edit, Fill, Series and complete in the appropriate data - linear type and step value of 1 in this case, but it can be non-linear using trend and Excel will intelligently (?) work out the sequence. You can also do dates.

6. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
I still don't understand the question

- C

7. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
Keep comin' back, CH.

8. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
bu...bu....but I really don't understand it, Dreamboat annie!

I mean that Q could mean a lot of things! I was merely cajoling!
Now I patiently wait for clarity!

- C

If you pick on me I'll send you more rain!

9. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne

Ah figger it lak thayus:
He wounce ta ayther hayev a noombered column, jest lak ther row noombers, ower he wounce ta hayev eggzistin noombers ta git a wown aydded ta it
Ayther why, hay's coovered bah ther ansers hay alraydy gawt

10. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
You're right!.... to hell with clarity!

The weekend is upon us - I hear the beach calling my name.
Clarity can wait for Monday morning's coffee.

gentleman.... the drinking lamp is lit!

Castleheart
PS: I'm actually from down Texas way. Why that stuff in your there answer ......that ain't no accent atall !

11. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
How about the smoking lamp? NOT THAT ONE!!! I KNOW WHERE YOUR HEAD'S AT!!! But SOME of us don't drink...

12. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
alright then....
an adirondack chair, a pale autumn breeze and a fine cigar...
- "rolled on the thighs of island women!"

Joined:
May 6, 2002
Messages:
882
Sorry it took so long to get back. I had a cllent that's system went completely down so was swamped.

I tried Kiwi guy's first and it worked perfectly. Thanks, Kiwi.

CH the question was this. In Excel if I have a column with values:

10
12
15
18

but wanted all records to be one increment:

11
13
16
18

What would I need to do?

Sorry I wasn't clear.

Thanks,everyone for all your help. This site is so great.

14. ### itsmeagain

Joined:
Sep 26, 2003
Messages:
10
Add a column to the right of the one you want to change, and add a formula (cell to the left) + 1, then copy it down the rest of the column - you can then hide the original column if you wish

15. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
itsmeagain:

He's already used kiwi's answer, which was best and easiest for his purposes.

As Seen On