Single filtered list from checkbox option grid

[AngleseyExcel]

I'm trying to think of the formula to create 1 single filtered list, showing which checkbox is True from the grid below ? Say the filtered list is in column H ?

 

[kevin9999]

This may do until a more elegant solution comes along. I've assumed that you link each checkbox with the cell in which it sits. I changed the font in those cells to white to not show the TRUE/FALSE values. The XL2BB doesn't show the checkboxes unfortunately, hence the image, but it does show the formula. You'll need to adjust the ranges to suit.

Book1
	B	C	D	E	F	G	H
3
4	FALSE	L1		L18	TRUE	L35	L2
5	TRUE	L2		L19		L36	L4
6		L3		L20		L37	L25
7	TRUE	L4		L21		L38	L35
8		L5		L22		L39	RU15
9		L6		L23		L40	L44
10		L7		L24	TRUE	RU15
11		L8	TRUE	L25		L42
12		L9		L26		L43
13		L10		L27	TRUE	L44
14		L11		L28		L45
15		L12		L29		L46
16
Sheet1

Cell Formulas
Range	Formula
H4:H9	H4	=LET(v,VSTACK($C$4:$C$15,$E$4:$E$15,$G$4:$G$15),FILTER(VSTACK($C$4:$C$15,$E$4:$E$15,$G$4:$G$15),VSTACK($B$4:$B$15,$D$4:$D$15,$F$4:$F$15)=TRUE,""))
Dynamic array formulas.

 

[kevin9999]

Here's a simpler formula, with your actual required ranges added.

checkboxes.xlsx
	B	C	D	E	F	G	H
3
4	FALSE	L1		L18	TRUE	L35	L2
5	TRUE	L2		L19		L36	L4
6		L3		L20	TRUE	L37	L25
7	TRUE	L4		L21		L38	L35
8		L5		L22		L39	L37
9		L6		L23		L40	L44
10		L7		L24	FALSE	RU15
11		L8	TRUE	L25		L42
12		L9		L26		L43
13		L10		L27	TRUE	L44
14		L11		L28		L45
15		L12		L29	FALSE	L46
16
Sheet1

Cell Formulas
Range	Formula
H4:H9	H4	=FILTER(VSTACK($C$4:$C$18,$E$4:$E$18,$G$4:$G$18),VSTACK($B$4:$B$18,$D$4:$D$18,$F$4:$F$18)=TRUE,"")
Dynamic array formulas.

FALSE​	L1		L18	TRUE​	L35	L2
TRUE​	L2		L19		L36	L4
	L3		L20	TRUE​	L37	L25
TRUE​	L4		L21		L38	L35
	L5		L22		L39	L37
	L6		L23		L40	L44
	L7		L24	FALSE​	RU15
	L8	TRUE​	L25		L42
	L9		L26		L43
	L10		L27	TRUE​	L44
	L11		L28		L45
	L12		L29	FALSE​	L46

 

[kevin9999]

A better graphic