Results 1 to 7 of 7
  1. #1
    The Robber
    Guest

    Cell formula that increases by more than one cell

    G'day

    I need to be able to create a formula that will take the values of cells in order. The exception is that the value will remain the same column but the row needs to be every 25 down. Eg. C1 = C10, D1 = C35, E1 = C60.

    Cheers Rob

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell formula that increases by more than one cell

    Enter the following in cells c1, d1, e1, ...

    =OFFSET($C$1,9+25*(COLUMN()-3),0)

    Is that what you need?

    Ian.

  3. #3
    The Robber
    Guest

    Re: Cell formula that increases by more than one cell

    John

    The situation I described is more complicated than I saked about hoping this would solv it. Can I email you the spready for you to have a look at. I need to be able to do this across different work sheets.

    Cheers Rob

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell formula that increases by more than one cell

    Rob,

    I'd encourage you to keep it public. You can attach a worksheet to your post if you want (as long as it's not too big).

    If it's kept public, it may help someone who comes along later looking for a similar solution
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    The Robber
    Guest

    Re: Cell formula that increases by more than one cell

    No probs

    YTD Consol worksheet G6 to G10 relates as the formulas suggest. I need H6 to H10 etc to relate to the same colums jsut 25 Cells below.

    Cheers Rob

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell formula that increases by more than one cell

    See attached for changes in H6:h10. The offset function works quite well in this sort of situation.

    JOn
    Attached Files Attached Files

  7. #7
    The Robber
    Guest

    Re: Cell formula that increases by more than one cell

    Jon,

    Sensation. I don't quite understand the column function with the -7 but it works and I'll endeavour to work that out.

    Cheers Rob

Posting Permissions

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