+ Reply to Thread
Results 1 to 3 of 3

Duplicating Values in a column

  1. #1
    Registered User
    Join Date
    04-24-2009
    Location
    San Francisco, Ca
    MS-Off Ver
    Excel 2003
    Posts
    28

    Duplicating Values in a column

    Hi all,

    I need to duplicate values in a column, and keep them in the order they are. For example in Column A I have:

    3
    6
    2
    4
    12
    45
    13

    I want to duplicate them, so in Column B for example it would look like:

    3
    3
    6
    6
    2
    2
    4
    4
    12
    12
    45
    45
    13
    13

    Seems like a pretty simple need but I can't figure out the formula.

    Any idea?
    Thanks
    Last edited by JoshD75; 03-05-2011 at 07:28 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Duplicating Values in a column

    Here, try this:

    =INDEX(A:A, 1+INT((ROWS($B$1:B1)-1)/2))

  3. #3
    Registered User
    Join Date
    04-24-2009
    Location
    San Francisco, Ca
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Duplicating Values in a column

    Quote Originally Posted by zbor View Post
    Here, try this:

    =INDEX(A:A, 1+INT((ROWS($B$1:B1)-1)/2))
    Perfect, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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