how to extract unique list of names in filtered data

Hello Excel Gurus
I'm learning excel, I'm able to make a unique list of names with FREQUENCY function but Im Not ablle make it with filtered data
As you can see from this table when i filter Yes or NOT the list of names as to be Unique list
see on the bottom the expected result
Bye and Thank you

	A	B	C
1	name	job	yes/not
2	frank	ggggg	yes
3	mike	ffffff	not
4	frank	hhhhh	yes
5	mike	jjjjj	yes
6	frank	kkkk	not
7	julie	lllll	yes
8	mike	aaaaa	not
9	frank	eeeee	yes
10	luis	ttttt	not
11
12
13
14
15
16
17	expected result	Unique list of	names filtered data
18	Result Yes	result NOT
19	Frank	Mike
20	Mike	frank
21	Julie	luis