+ Reply to Thread
Results 1 to 3 of 3

Prefilling 10 rows in one column based on 1 row from another

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    Turkey
    MS-Off Ver
    2013
    Posts
    4

    Prefilling 10 rows in one column based on 1 row from another

    This should be so simple, yet my brain cannot see it. Any help from you guys would be really appreciated

    COL A has 1300 rows.
    COL B is currently blank.

    Need to fill every 10 rows in COL B with a value from 1 row of COL A, then repeat.

    Result would look like this:

    COL A (static values, but 1300 rows)
    1
    2
    3
    4
    5
    6
    ...

    COL B (13,000 rows when completed)
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    2
    2
    2
    2
    2
    2
    2
    2
    2
    2
    3
    3
    3
    3
    3
    3
    3
    3
    3
    3
    ...

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Prefilling 10 rows in one column based on 1 row from another

    In B1, enter

    =INDEX(A:A,INT((ROW()+9)/10))

    and copy down for 13000 rows.
    Last edited by Bernie Deitrick; 10-02-2015 at 10:20 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    10-07-2014
    Location
    Turkey
    MS-Off Ver
    2013
    Posts
    4

    Re: Prefilling 10 rows in one column based on 1 row from another

    Many thanks Bernie - that worked a treat :D
    And I learned something new too...

    Cheers

+ 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. Replies: 5
    Last Post: 05-08-2014, 07:24 AM
  2. Replies: 8
    Last Post: 08-08-2013, 08:45 AM
  3. [SOLVED] Filter rows based on unique values in one column + specific value in another column
    By Dieneces in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 09:55 AM
  4. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  5. [SOLVED] VBA macro that hide and unhide column to respective rows based on first column value
    By janine6192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 06:21 PM
  6. Prefilling cells with IF statment?
    By qvp in forum Excel General
    Replies: 3
    Last Post: 02-24-2012, 05:29 AM
  7. [SOLVED] Auto Fill Column with Date based on rows in other column
    By JOUIOUI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2006, 01:35 PM

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