Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Repeat value -1 (2003)

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

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #4
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •