if i insert a value on a cell it will filter a column and give the data to a column

[mark692]

i have this 2 table
table 1 is a table with name and a group and table 2 is column for name. i want a formula that will give me the names from column B to column D depending on a group letter that i will put on cell D1. if i put group A names on table 2 will appear that have a group A on table 1. is that possible in excel formula?

sample table below

Book1
	A	B	C	D
1			Group	A
2	Name	Group		Name
3	Mickey	A		Mickey
4	Minnie	A		Minnie
5	Goofy	A		Goofy
6		A
7		A
8		A
9	Gokou	B
10	Gohan	B
11	Goten	B
12		B
13		B
14	sailor moon	C
15	Sailor Mars	C
16		C
17		C
Sheet1

 

[Peter_SSs]

is that possible in excel formula?

Sure. With your 2016 version of Excel, try this, copied down.

20 07 24.xlsm
	A	B	C	D
1			Group	A
2	Name	Group		Name
3	Mickey	A		Mickey
4	Minnie	A		Minnie
5	Goofy	A		Goofy
6		A
7		A
8		A
9	Gokou	B
10	Gohan	B
11	Goten	B
12		B
13		B
14	sailor moon	C
15	Sailor Mars	C
16		C
17		C
18
19
20
Names

Cell Formulas
Range	Formula
D3:D20	D3	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(B$3:B$20)/((B$3:B$20=D$1)*(A$3:A$20<>"")),ROWS(D$3:D3))),"")

 

[mark692]

Sure. With your 2016 version of Excel, try this, copied down.

20 07 24.xlsm
	A	B	C	D
1			Group	A
2	Name	Group		Name
3	Mickey	A		Mickey
4	Minnie	A		Minnie
5	Goofy	A		Goofy
6		A
7		A
8		A
9	Gokou	B
10	Gohan	B
11	Goten	B
12		B
13		B
14	sailor moon	C
15	Sailor Mars	C
16		C
17		C
18
19
20
Names

Cell Formulas
Range	Formula
D3:D20	D3	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(B$3:B$20)/((B$3:B$20=D$1)*(A$3:A$20<>"")),ROWS(D$3:D3))),"")

thank you sir this works!

 

[Peter_SSs]

thank you sir this works!

You're welcome. Thanks for the follow-up.