Create a unique list using data validation.

See the information at the top of the page to help you provide a sample workbook.

I don't think you are giving the whole picture. Where have the items in green come form?

Excel 2016 (Windows) 32 bit

	H	I	J	K	L	M
8	A				Manager	Employee
9	aaaa				A	aaaa
10	aaaa				B	cccc
11	hhh				C	ddd
12	hhh				C	eee
13	hhh				B	fff
14	hhh				A	hhh

Sheet: Sheet1

1. Create a new tab called LOOKUP and type this into B2:

=IFERROR(SUBSTITUTE(INDEX('Empl Master'!$B$2:$B$300,MATCH(0,INDEX(COUNTIF($A$1:A1,'Empl Master'!$B$2:$B$300),0,0),0)),0,""),"")

Drag copy down, then type All into A1.

2. In B1 on the Current tab, create the data validation list using this range as the source: =Lookup!$A$1:$A$5

3. Type this into B3:

=IFERROR(INDEX('Empl Master'!$A$2:$A$7,AGGREGATE(15,6,ROW('Empl Master'!$A$2:$A$7)/(IF(Current!$B$1="All",1,'Empl Master'!$B$2:$B$7=Current!$B$1)),ROWS($B$2:B2))-ROW($A$2)+1),"")

Drag copy down.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.