# Thread: Repeat value -1 (2003)

1. ## Repeat value -1 (2003)

I have a column of numbers starting out with 134. There must be a formula to decrease the value from 134 by 1 for each cell in the column until reaching 0, but I don't know what it is. The result should look like this:
134
133
132
and so on.

2. ## Re: Repeat value -1 (2003)

In Cell A1 type 134, in A2 type=A1-1 drag that cell value down to A135

3. ## Re: Repeat value -1 (2003)

Put 134 in first cell and select it
Edit - fill -series
check "column"
Type: Linear
Step: -1
Stop value: 0
<ok>

You can also enter 134 and 133 in the first 2 cells and select them
Then select the bottom right corner of the selection and drag it down until the "popup" indicates "0"

Steve

Steve

4. ## Re: Repeat value -1 (2003)

Thanks, both of you! Very slick! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•