Reference unique values in specific group to another worksheet

[chucklebunny]

I need to reference the unique members of a specific group. I've tried several attempts at VLOOKUP and INDEX but none have generated what I'm trying to accomplish. I have a list of individuals with varying group numbers. There are Five (5) total members per group. I need to pull the names of all group members by group. The formulas I've tried all end up with duplicates rather than individual names. I also cannot sort the data by Group number due to the size of the data set; I need to be able to automatically pull the data without any sorting. Any help would be much appreciated!

 

[StephenCrump]

Welcome to the Forum!

At its simplest:

	A	B	C	D	E
1
2	1	John		Get group	1
3					John
4					James
5	1	James			Becky
6					Craig
7	1	Becky			Britney
8	1	Craig
9
10
11	1	Britney
12
Sheet1

Cell Formulas
Range	Formula
E3:E7	E3	=FILTER(B2:B11,A2:A11=E2)
Dynamic array formulas.

If names can occur more than once, wrap the formula in UNIQUE()

And in SORT() if you want the results alphabetical