+ Reply to Thread
Results 1 to 6 of 6

Consecutive repeat of column headings based on cell values

  1. #1
    Registered User
    Join Date
    06-19-2009
    Location
    Dingwall
    MS-Off Ver
    Excel 2010
    Posts
    8

    Consecutive repeat of column headings based on cell values

    Hi there,

    I hopefully have a relatively simple problem for you geniuses out there. I essentially want to repeat the values in Row 2 (attached file) the defined number of times for each 'Cluster'. Where the value is zero, that particular value is skipped. I am not great at INDEX, MATCH etc but I am sure there must be a solution surrounding these functions. My final output will be a graphic with coloured symbols represented by each number value, but if I can solve this wee problem the rest should be relatively simple (I hope ).

    Apologies if there is already a solution to my problem, happy to take a link if somebody knows of one. I have seen a few relating to repeating columns of values but not rows like this. It's driving me up the wall as I should be able to do this!

    Many many thanks,

    Mike
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Consecutive repeat of column headings based on cell values

    Hi

    Try this formula in I3 and copy down and forward
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,997

    Re: Consecutive repeat of column headings based on cell values

    Another ..

    in I3

    Please Login or Register  to view this content.

    copy down and across

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Consecutive repeat of column headings based on cell values

    Removed by FR. Too close to what José posted.
    Last edited by FlameRetired; 05-23-2018 at 04:11 PM.
    Dave

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Consecutive repeat of column headings based on cell values

    Removed. Double-posted.

  6. #6
    Registered User
    Join Date
    06-19-2009
    Location
    Dingwall
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Consecutive repeat of column headings based on cell values

    John, bread and butter for you I'm sure but genius as far as I am concerned, many thanks! I would never have figured that one out in such a short space of time.

    Your solution was also great José but wasn't quite suitable as I omitted to say that the sum of each row from Cluster 1 onwards can be higher than 5, which I think is why it didn't work as expected. I should have given the heads up on that one!

    Thanks again

+ 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. Show column headings and corresponding values/text based on dropdown selection
    By deedee90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2018, 07:03 AM
  2. Summing values based on criteria located in column and row headings
    By talbarnett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 02:18 AM
  3. Need to convert cell values to column headings
    By faizaan316 in forum Excel General
    Replies: 1
    Last Post: 05-02-2013, 01:03 PM
  4. Replies: 2
    Last Post: 07-23-2010, 10:11 AM
  5. How to repeat column headings on sheet 2
    By wlarson in forum Excel General
    Replies: 1
    Last Post: 12-31-2007, 04:31 PM
  6. Replies: 1
    Last Post: 11-09-2005, 09:20 PM
  7. Replies: 1
    Last Post: 09-16-2005, 12:05 AM

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