+ Reply to Thread
Results 1 to 7 of 7

copying a formula to 8 cells lower with a result of 1 cell lower

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    copying a formula to 8 cells lower with a result of 1 cell lower

    i need help to create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    Your heading doesn't tie in with what you have written below it in the main text. Please explain your requirements more clearly.

    Pete

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    oops sorry. typo error. what i meant was copying a formula from cell a5 to a13 but the result would be 1 cell lower from a5's.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    What formula do you have in cell A5, and how do you want it to change in A13?

    Pete

  5. #5
    Registered User
    Join Date
    09-30-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    hi Pete,

    Here it is. my formula in cell a5 is "=Sheet1!A1". I want to copy it to cell a13 but the result would be equivalent to "=sheet1!A2".

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    Put this formula in A5:

    =INDEX(Sheet1!A:A,INT((ROWS($1:1)-1)/8)+1)

    Then copy it into A13, A21, A29 etc.

    Hope this helps.

    Pete

  7. #7
    Registered User
    Join Date
    09-30-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: copying a formula to 8 cells lower with a result of 1 cell lower

    thanks Pete. It really helped alot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula that Transforms Cell Column into Lower Case and replaces spaces with hyphens
    By diemking in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2013, 12:50 AM
  2. Replies: 1
    Last Post: 03-29-2012, 05:41 AM
  3. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  4. Comparing cells and result enters the lower value
    By kayone in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-31-2009, 07:02 PM
  5. Choose between two cells the lower result of a formula
    By Michael Zullo via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 03:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1