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 1	Out	Active	Production	Days	Pogs
Employee 2	Out	Active	Production	Nights	Tazo
Employee 3	Out	Active	Production	Days	Pogs
Employee 3	Out	Active	Production	Days	Pogs
Employee 4	Out	Active	Production	Days	Pogs
Employee 5	Out	Active	Production	Nights	Pogs
Employee 6	Out	Active	Production	Days	Pogs
Employee 7	Out	Active	Production	Days	Tazo
Employee 7	Out	Active	Production	Days	Tazo
Employee 7	Out	Active	Production	Days	Tazo
Employee 8	Out	Active	Production	Days	Tazo
Employee 9	Out	Active	Production	Nights	Tazo
Employee 10	Out	Active	Production	Nights	Tazo

<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>
[TD="width: 175"]Employee Name[/TD]
[TD="width: 124"]Department Name[/TD]
[TD="width: 96"]Status[/TD]
[TD="class: xl67, width: 75"]Date[/TD]
[TD="width: 43"]Hours[/TD]
[TD="width: 119"]Process[/TD]
[TD="width: 64"]Day/Night[/TD]
[TD="width: 64"]Business[/TD]
[TD="width: 75"]Week[/TD]
[TD="width: 64"]Year[/TD]

[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]17/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]12[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]

</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.

[TABLE="width: 405"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]10/03/2019[/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD][/TD]
[TD]12/03/2019[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD][/TD]
[TD]Employee 2[/TD]
[TD][/TD]
[TD]Employee 3[/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD][/TD]
[TD]Employee 5[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[/TR]
[TR]
[TD]Employee 6[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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