Finding the first, then second, then third selection

I have a workbook where I'm trying to collect a group of data points based on checkbox selections that determines which groups of data are to be presented. I'm trying to show only the groups of data that are selected but I'm also trying to remove the blank sections in my results. The groups selected should be presented side by side.

The attached spreadsheet shows the data as it'll be presented and also shows the results I'm trying to achieve. I've had various results where rows of data is repeated, or just skipped over. I can get the first two rows to work properly but after that I'm not able to find a reasonable logic to make it work properly.

I appreciate the slicer suggestion but to make it easier to provide an example spreadsheet I didn't present the whole picture...literately. Beside each set of data points, there's also a picture and the user will be scrolling through a bunch more potential options to select from, not just the 6 I gave in the example. I would prefer that the user be able to select what they see as they are scrolling through the options and not have to find a slicer to make their selection from. The image below should help to get a better sense of how this looks.

Capture.PNG

I'm not looking for a solution to my data needs, just a solution to the grouping I presented in my initial post and attachment. I was able to come close to a solution but after a couple rows into it, some of the logic fell apart but it's not outside the realm of a formula, or maybe even a pivot table to be able to do it, and doesn't require anything more than Excel to accomplish, just some additional logic which Excel can do just fine. I purposefully didn't initially share the second post with the picture just to prevent making this seem a much more difficult task. This is exactly a tabular data need.

I very much appreciate that you would offer some advice but I don't appreciate the suggestion that it can't be done just because you can't see a way to do it. I hope that others will still consider trying...

It's not that I didn't like the answer I got but you didn't offer a solution. I even acknowledged you and appreciated that you would take the time to offer some advice, but instead you only suggested that a solution couldn't be had because of your "years of experience" didn't prepare you with a solution, so you deemed it necessary to take your personal frustration at a lack of a solution on me.

Well, I've got many years of experience as well and despite all that I do know, I still know that I can always be wrong and that there's always room to learn more.

I'm happy that you feel that there's nothing more for you to learn about the capabilities of an application you spend much time on, I just don't believe that you're the arbiter of the complete set of capabilities that Excel offers and I believe a solution exists. I'm just asking that others don't get put off by your aggression towards me and maybe someone else can come up with a solution that escapes your years of experience. Perhaps you could learn something new that you didn't know before.

Helper in Row 17

in F17

=SMALL(IF(TRANSPOSE($A$5:$A$10)=TRUE,COLUMN($A:$F),""),COLUMNS($A:A))


...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across

in F20

=IFERROR(INDEX($D$4:$D$45,(F$17-1)*7+1+ROWS($1:1)),"")

copy across and down

JT, many thanks...I believe that I too came across a similar solution after getting told it couldn't be done (I hate not being able to do something). My solution also uses a helper row to create the same result, but it required some additional helper columns so your solution is much more flexible. Mine needed some extra rows at the top...

Your solution is very much appreciated...thank you!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.