Results 1 to 5 of 5

Copy value X number of times down column

Threaded View

CCollin Copy value X number of times... 03-24-2014, 01:47 PM
AlKey Re: Copy value X number of... 03-24-2014, 01:57 PM
CCollin Re: Copy value X number of... 03-24-2014, 02:11 PM
AlKey Re: Copy value X number of... 03-24-2014, 02:20 PM
Tony Valko Re: Copy value X number of... 03-24-2014, 03:01 PM
  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    CT, USA
    MS-Off Ver
    Excel 2011
    Posts
    2

    Copy value X number of times down column

    I found the following formula on another thread and it works perfectly until I get to a second listing of the same item.
    =IF(COUNTIF($E$5:E5,E5)=INDEX(B:B,MATCH(E5,A:A,0)),INDEX(A:A,MATCH(E5,A:A,0)+1),E5)

    Example:
    Item # of occurrences
    Sugar Melt 3
    Summer Beauty 1
    Blue Ice 1
    Sugar Melt 1
    Hot Lips 1

    I want it to be listed this way:
    Sugar Melt
    Sugar Melt
    Sugar Melt
    Summer Beauty
    Blue Ice
    Sugar Melt
    Hot Lips

    But when it gets the the second Sugar Melt the formula will only return Sugar Melt. Is there a way to fix this?
    This is part of a larger workbook so the Items are extracted from another sheet and will not be combined or sorted in this list.

    I have attached a workbook with more detail.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy set number of cells a set number of times within same worksheet
    By hal9000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2013, 11:51 AM
  2. Copy and Paste data in column A number of times displayed in column B
    By anthony232 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2013, 05:13 PM
  3. Copy column variable number of times between start date and end date
    By gbisk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 07:57 AM
  4. [SOLVED] count the number of times each string appears in a column and make a summary column
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2012, 08:02 AM
  5. [SOLVED] find number of times a letter or a number appears in a column
    By dcoates in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2012, 02:47 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