+ Reply to Thread
Results 1 to 4 of 4

Multiple name duplication

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Multiple name duplication

    I have a list of names (Colom A) that I want to duplicate (Colom B) , each name need to repeat 3 times before moving on to the next name on the list

    Colom A Colom B

    Name A Name A
    Name B Name A
    Name C Name A
    Name B
    Name B
    Name B
    Name B
    Name C
    Name C
    Name C

    Thanks in advance for your help!
    Last edited by ysaroya; 01-14-2019 at 07:46 AM.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Multiple name duplication

    If your names are in A1:A3 then

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple name duplication

    Quote Originally Posted by ysaroya View Post
    I have a list of names (Colom A) that I want to duplicate (Colom B) , each name need to repeat 3 times before moving on to the next name on the list

    Colom A Colom B

    Name A Name A
    Name B Name A
    Name C Name A
    Name B
    Name B
    Name B
    Name B
    Name C
    Name C
    Name C

    Thanks in advance for your help!
    It did alittle mess after posting....Colom A - Name A, Name B, Name C
    Colom B - Name A, Name A, Name A, Name B, Name B, Name B, Name C, Name C, Name C.

  4. #4
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple name duplication

    Thanks A LOT!!!!
    you guys are awesome!

+ 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. Merging data from multiple sheets without duplication
    By 5degrees in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2018, 01:23 PM
  2. Multiple Duplication of sheets based on a QTY cell value
    By Nash_ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-08-2018, 01:57 PM
  3. [SOLVED] Count Without Duplication Multiple Criteria
    By chadmott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2016, 10:22 AM
  4. Prevent duplication in multiple column
    By Vandini.S in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-09-2015, 02:42 AM
  5. multiple lookup and duplication finding
    By Ekac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2015, 11:00 AM
  6. Replies: 2
    Last Post: 04-09-2014, 03:05 PM
  7. Multiple Userforms - Avoid code duplication
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2006, 11:25 PM

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