Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need formula to... (2000 sr 1)

    into sheet DECADE in line 2 range C2, F2, I2 is present a formula.
    How can use this formula for all range from M4 to DO2... similar a pull on right to fill the range...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need formula to... (2000 sr 1)

    See attached. The formula in C2 is now

    =MOD(COLUMN(),10)/3&" DEC. "&OFFSET(DATE!$A$2,TRUNC(COLUMN()/10),MOD(COLUMN(),10)/3)

    and this has been copied to the other cells in row 2.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need formula to... (2000 sr 1)

    how!!!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need formula to... (2000 sr 1)

    How what?

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need formula to... (2000 sr 1)

    Sorry. WOW!!!!!!!!!!!!!!
    I dont know the word in english when a code is wanderfull?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need formula to... (2000 sr 1)

    Wow will do. Thank you.

Posting Permissions

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