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	X	X	X	X	A
B	X	X	X	Z	B
C	X	X	X	Z	C
D	X	X	X	F
E	X	X	Y	X
F	X	X	X

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
[TH="align: center"][/TH]
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]
[TH="align: center"]C[/TH]
[TH="align: center"]D[/TH]
[TH="align: center"]E[/TH]
[TH="align: center"]F[/TH]
[TH="align: center"]G[/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]

</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"]X[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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.