+ Reply to Thread
Results 1 to 8 of 8

Repeat Item a Number of Times based on Cell Value

Hybrid View

  1. #1
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,651

    Re: Repeat Item a Number of Times based on Cell Value

    @Estevaoba,
    to avoid sucuri firewall, try to add space before and after the greater/smaller sign, like this: " > "

    @djhantulip,
    Try in J6=C6
    J7:
    =IFERROR(IF(COUNTIF($J$5:J6,J6) < VLOOKUP(J6,$C$6:$D$28,2,0),J6,INDEX($C$6:$C$28,MATCH(J6,$C$6:$C$28,0)+1)),"")
    Drag down
    Quang PT

+ 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: 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