Results 1 to 8 of 8

Repeat Item a Number of Times based on Cell Value

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    Bolivia
    Posts
    42

    Question Repeat Item a Number of Times based on Cell Value

    Hello all!

    I have a quick problem that hopefully someone can help me with

    Basically I have column C which has Item numbers for different products. This list, in my original workbook, is generated using dynamic arrays, so it is dynamic and automatic.

    I also have column D which has the number of times I want the item number to be repeated (this list is also generated using dynamic arrays in my original workbook).

    What I need is shown in column G.
    As you can see the items are in one column repeated the number of times that is specified in column B.

    How could I accomplish this?
    If at all possible, maybe try to make the solution use dynamic arrays so everything is automatic and dynamic?
    If not possible, any other type of formula will be well received and deeply thanked!

    I thank you in advance for the help!

    Best regards!

    segrxgW.png
    ________________________
    Orlando Nunez B., M.S.
    Project Engineer
    IASA Construction Company
    Santa Cruz - Bolivia

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2015, 02:56 AM
  2. Repeat cell values a certain number of times
    By strother1990 in forum Excel General
    Replies: 2
    Last Post: 09-24-2014, 12:43 PM
  3. Macro or Eqn to Repeat Formula "X" times based on Number in Cell
    By waltheaj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 12:24 PM
  4. [SOLVED] Repeat item 12 times for 12 months
    By BHammy in forum Excel General
    Replies: 5
    Last Post: 10-05-2012, 12:01 PM
  5. Replies: 1
    Last Post: 10-04-2012, 01:53 PM
  6. How to repeat a macro x number of times based on a value in a cell
    By gypsyhotelier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2011, 05:11 PM
  7. Repeat a cell value in another column X number of times
    By art1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-31-2011, 02:36 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