Pull unique names refrencing date field

[StephenM123]

Afternoon all,

I'm looking for a bit of help on the following.
I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether.

I would like to create some sort of custom calendar, using only formula from a list of data, extract provided below.
The list currently extends some 1000 rows and will continue to expand.

Employee Name	Department Name	Status	Date	Hours	Process	Day/Night	Business	Week	Year
Employee 1	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019
Employee 2	Out	Active	11/03/2019	10	Production	Nights	Tazo	11	2019
Employee 3	Out	Active	12/03/2019	10	Production	Days	Pogs	11	2019
Employee 3	Out	Active	13/03/2019	10	Production	Days	Pogs	11	2019
Employee 4	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019
Employee 5	Out	Active	11/03/2019	10	Production	Nights	Pogs	11	2019
Employee 6	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019
Employee 7	Out	Active	11/03/2019	10	Production	Days	Tazo	11	2019
Employee 7	Out	Active	12/03/2019	10	Production	Days	Tazo	11	2019
Employee 7	Out	Active	13/03/2019	10	Production	Days	Tazo	11	2019
Employee 8	Out	Active	17/03/2019	10	Production	Days	Tazo	12	2019
Employee 9	Out	Active	10/03/2019	3	Production	Nights	Tazo	11	2019
Employee 10	Out	Active	10/03/2019	10	Production	Nights	Tazo	11	2019

<colgroup><col style="mso-width-source:userset;mso-width-alt:6400;width:131pt" width="175"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

What I would ideally like to be able to do is pull a list of which employee is off on each day in to something similar to the format below.
I'm really struggling with how I pick up the next 'employee name' value in the lists.

10/03/2019		11/03/2019		12/03/2019
Employee 1		Employee 2		Employee 3
Employee 4		Employee 5		Employee 7
Employee 6		Employee 7
Employee 9
Employee10

<colgroup><col span="5"></colgroup><tbody>
</tbody>

Ideally after this I would like to split it out by if they work day shift or night shift as well but I should hopefully be able to do that once I get started.

Any helps on what I'm looking for would be greatly appreciated.

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Employee Name	Department Name	Status	Date	Hours	Process	Day/Night	Business	Week	Year			10/03/2019	11/03/2019	12/03/2019
2	Employee 1	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019			Employee 1	Employee 2	Employee 3
3	Employee 2	Out	Active	11/03/2019	10	Production	Nights	Tazo	11	2019			Employee 4	Employee 5	Employee 7
4	Employee 3	Out	Active	12/03/2019	10	Production	Days	Pogs	11	2019			Employee 6	Employee 7
5	Employee 3	Out	Active	13/03/2019	10	Production	Days	Pogs	11	2019			Employee 9
6	Employee 4	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019			Employee 10
7	Employee 5	Out	Active	11/03/2019	10	Production	Nights	Pogs	11	2019
8	Employee 6	Out	Active	10/03/2019	10	Production	Days	Pogs	11	2019
9	Employee 7	Out	Active	11/03/2019	10	Production	Days	Tazo	11	2019
10	Employee 7	Out	Active	12/03/2019	10	Production	Days	Tazo	11	2019
11	Employee 7	Out	Active	13/03/2019	10	Production	Days	Tazo	11	2019
12	Employee 8	Out	Active	17/03/2019	10	Production	Days	Tazo	12	2019
13	Employee 9	Out	Active	10/03/2019	3	Production	Nights	Tazo	11	2019
14	Employee 10	Out	Active	10/03/2019	10	Production	Nights	Tazo	11	2019
Master

Cell Formulas
Range	Formula
M2	=IFERROR(INDEX($A$2:$A$14,AGGREGATE(15,6,(ROW($A$2:$A$14)-ROW($A$2)+1)/(($D$2:$D$14=M$1)*($B$2:$B$14="Out")),ROWS($A$1:$A1))),"")

 

[StephenM123]

This worked a treat. Thank you for the help.

My next step I plan on is looking it up and splitting it in to 2 sections one for days and one for nights.

 

[Fluff]

You're welcome & thanks for the feedback.
If you have problems with the next step, just post back