Return All values matching criteria of Another Column

Enter array formula in D2 and drag formula across and down

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Formula:

=IFERROR(INDEX($A:$A,SMALL(IF($B$2:$B$10=D$1,ROW(B$2:B$10)),ROWS(D$2:D2))),"")

Or you can also use regular formula (for Excel 2010 and up)

Formula:

=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($B$2:$B$10)/($B$2:$B$10=D$1),ROWS(D$2:D2))),"")

Format as Date

v	A	B	C	D	E	F	G
1	Date	Team Member		Joe	Nick	Sam	Cody
2	9/1/2017	Joe		9/1/2017	9/8/2017	9/15/2017	9/29/2017
3	9/8/2017	Nick		10/6/2017	9/22/2017	10/20/2017	10/27/2017
4	9/15/2017	Sam			10/13/2017
5	9/22/2017	Nick
6	9/29/2017	Cody
7	10/6/2017	Joe
8	10/13/2017	Nick
9	10/20/2017	Sam
10	10/27/2017	Cody

Here is an thread to filter with formulas
https://www.excelforum.com/tips-and-...-examples.html
Attached is a simple example

edit:Right on AlKey....simpler than mine