+ Reply to Thread
Results 1 to 3 of 3

Incrementing Rows in Excel

  1. #1
    Registered User
    Join Date
    11-26-2008
    Location
    Canada
    Posts
    2

    Smile Incrementing Rows in Excel

    Needs some help with a formula....

    I currently have a Text Value in a cell....Let's say A1 has a text Value of "Joe"
    In row 201 I want it to equal the value of A1
    So
    A201 = A1
    Now I need to be able to copy a formula to every 3rd line below A201 which would be equal to A2.....

    So you would end up with:
    A201 = A1
    A204 =A2
    I would like to be able to copy a formula down as it is very time consuming....I know I could use VBA to have it equal...the cell..but wondering if there may be something i could add outside of using VBA.....
    Your help is appreciated.
    Last edited by bfancy; 11-26-2008 at 11:14 AM. Reason: need to modify Header

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Thanks.

    In A201, =INDEX($A:$A, INT( (ROW() - 201) / 3) + 1)

    Then select A201:A203 (all three cells, including two blanks) and drag down the fill handle.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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