Dynamic List Based on 'X' Marks in Table

[jimmycooker]

Hi,

Can someone help me with a formula to get this subset of letters:

1 2 3 4 5 6 7
A x x x x x
B x x x x
C x x x x
D x x x x x
E x x x x
F x x x x

Create Dynamic List of letters 'A to F' based on cell reference '5'

Result required (based on 'X' marks):

A
C
D
E

 

[jimmycooker]

Not quite there.....

Let me explain myself better.....so to add conditionality to the table, in certain instances there might be a Y or a Z

So i will always need to return the X items, but the 'Y' & 'Z' items would depend on a cell Value (say 'Yes' or 'No') indicating whether to include those items....

 

[Fluff]

Can you please supply some sample data, as I'm now completely lost.
There are some add-ins available here, that will help with that https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[jimmycooker]

How about

	A	B	C	D	E	F	G	H	I	J
1		1	2	3	4	5	6	7		6
2	A	X		X		X	X	X		A
3	B		X	X	X		Z			B
4	C	X		X		X	Z			C
5	D			X		X		X		F
6	E	X		X			Y	X
7	F		X		X		X

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Row 1 = 6
Include Table Reference 'X'? Yes
Include Table Reference 'Y'? No
Include Table Reference 'Z'? Yes

 

[Fluff]

One option would be

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1		1	2	3	4	5	6	7		6
2	A	X		X		X	X	X		Z	A
3	B		X	X	X		Z				B
4	C	X		X		X	Z				C
5	D			X		X		X			F
6	E	X		X			Y	X
7	F		X		X		X
All

Cell Formulas
Range	Formula
K2	=IFERROR(INDEX($A$2:$A$7,AGGREGATE(15,6,ROW($A$2:$A$7)-ROW($A$2)+1/(($B$1:$H$1=$J$1)*(($B$2:$H$7="X")+($B$2:$H$7=$J$2))),ROWS($1:1))),"")

But I don't know how to run an if condition inside that formula.