I need a combination of XLOOKUP and FILTER for an HR Dashboard to show monthly leavers. Formula can be updated using dropdown.

[maxim642]

1.3.21 HR Dashboard ML.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Full Name	Employee Number	Job Title	Job Level	Salary	Company	Division	Department	Status	Employee Type	Manager Full Name	Start Date	Continuous Start Date	Leaving Date	Location	Gender	Email	Contract End Date	Standard Hours	Disabled	Car Allowance	Actual FTE	Cost Centre	Ethnicity	LoS Date	Full Time Y/N	Start Year	Start Month	Leave Year	Leave Month	LoS (Days)	Los (Years)	Actual Start Date	Formatted Leave Date
2	Worker 1	1	JT1	JL1	50k	X	Test 1	Dep 1	Current	Employee	Man 1	1/13/11		5/13/15	London	Male	test1		37.5	No	0	1	cc1	White - Any other background	5/13/15	Yes	2011	Jan	2015	May	1581	4.3	1/13/11	5/13/15
3	Worker 2	2	JT2	JL2	50k	X	Test 2	Dep 2	Current	Employee	Man 2	3/1/19			London	Male	test2			No	0	1	cc2	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2019	Mar			731	2.0	3/1/19
4	Worker 3	3	JT3	JL3	50k	X	Test 3	Dep 3	Current	Employee	Man 3	1/11/21			London	Male	test3			No	0	1	cc3	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2021	Jan			49	0.1	1/11/21
5	Worker 4	4	JT4	JL4	50k	X	Test 4	Dep 4	Former	Employee	Man 4	1/1/12		7/15/20	London	Male	test4		37.5	No	0	1	cc4	White - English, Welsh, Scottish, Northern Irish, British	7/15/20	Yes	2012	Jan	2020	Jul	3118	8.5	1/1/12	7/15/20
6	Worker 5	5	JT5	JL5	50k	X	Test 5	Dep 5	Current	Employee	Man 5	1/4/21			London	Female	test5			No	0	1	cc5	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2021	Jan			56	0.2	1/4/21
7	Worker 6	6	JT6	JL6	50k	X	Test 6	Dep 6	Current	Employee	Man 6	9/30/19			Milton Keynes	Male	test6			No	0	1	cc6		3/1/21	Yes	2019	Sep			518	1.4	9/30/19
8	Worker 7	7	JT7	JL7	50k	X	Test 7	Dep 7	Current	Employee	Man 7	1/16/14			London	Male	test7		37.5	No	0	1	cc7	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2014	Jan			2601	7.1	1/16/14
9	Worker 8	8	JT8	JL8	50k	X	Test 8	Dep 8	Former	Employee	Man 8	3/3/86		9/30/20	Home	Male	test8			No	0	1	cc8		9/30/20	Yes	1986	Mar	2020	Sep	12630	34.6	3/3/86	9/30/20
10	Worker 9	9	JT9	JL9	50k	X	Test 9	Dep 9	Former	Employee	Man 9	9/1/20	9/30/19	9/25/20	Home Based	Male	test9			No	0	1	cc9	White - English, Welsh, Scottish, Northern Irish, British	9/25/20	Yes	2019	Sep	2020	Sep	361	1.0	9/30/19	9/25/20
11	Worker 10	10	JT10	JL10	50k	X	Test 10	Dep 10	Current	Employee	Man 10	8/6/12			London	Male	test10		37.5	No	0	1	cc10	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2012	Aug			3129	8.6	8/6/12
12	Worker 11	11	JT11	JL11	50k	X	Test 11	Dep 11	Current	Employee	Man 11	9/9/19		2/29/16	London	Male	test11		37.5	No	0	1	cc11	White - English, Welsh, Scottish, Northern Irish, British	2/29/16	Yes	2019	Sep	2016	Feb	-1288	-	9/9/19	2/29/16
13	Worker 12	12	JT12	JL12	50k	X	Test 12	Dep 12	Current	Employee	Man 12	5/21/18		8/20/18	London	Female	test12			No	0	1	cc12		8/20/18	Yes	2018	May	2018	Aug	91	0.2	5/21/18	8/20/18
14	Worker 13	13	JT13	JL13	50k	X	Test 13	Dep 13	Current	Employee	Man 13	12/3/18			London	Male	test13		37.5	No	0	1	cc13	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2018	Dec			819	2.2	12/3/18
15	Worker 14	14	JT14	JL14	50k	X	Test 14	Dep 14	Current	Employee	Man 14	4/1/03	4/1/03		Telford	Female	test14		37.5	No	0	1	cc14	Chinese - British	3/1/21	Yes	2003	Apr			6544	17.9	4/1/03
16	Worker 15	15	JT15	JL15	50k	X	Test 15	Dep 15	Former	Employee	Man 15	5/1/12		7/1/19	London	Male	test15		37.5	No	0	1	cc15	White - English, Welsh, Scottish, Northern Irish, British	7/1/19	Yes	2012	May	2019	Jul	2617	7.2	5/1/12	7/1/19
17	Worker 16	16	JT16	JL16	50k	X	Test 16	Dep 16	Current	Employee	Man 16	4/2/19	4/2/19		London	Male	test16		37.5	No	0	1	cc16	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2019	Apr			699	1.9	4/2/19
18	Worker 17	17	JT17	JL17	50k	X	Test 17	Dep 17	Current	Employee	Man 17	9/7/20			London	Male	test17			No	0	1	cc17	White - English, Welsh, Scottish, Northern Irish, British	3/1/21	Yes	2020	Sep			175	0.5	9/7/20
19	Worker 18	18	JT18	JL18	50k	X	Test 18	Dep 18	Current	Employee	Man 18	12/1/13		7/8/21	London	Male	test18		37.5	No	0	1	cc18	White - English, Welsh, Scottish, Northern Irish, British	7/8/21	Yes	2013	Dec	2021	Jul	2776	7.6	12/1/13	7/8/21
20
21	2015	Jan
22	Month	Full Name	Company	Department	Division	Location	Job Title	Start Date	Leaving Date	LoS Years	Employee Type			2015	Jan
23														2016	Feb
24														2017	Mar
25														2018	Apr
26														2019	May
27														2020	Jun
28														2021	Jul
29														2022	Aug
30															Sep
31															Oct
32															Nov
33															Dec
34
35
36
37
38
Sheet2

Cell Formulas
Range	Formula
Y2:Y19	Y2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2))),TODAY(),N2)
Z2:Z19	Z2	=IF(V2>=1,"Yes","No")
AA2:AA19	AA2	=TEXT(AG2,"YYYY")
AB2:AB19	AB2	=TEXT(AG2,"MMM")
AC2:AC19	AC2	=TEXT(N2,"YYYY")
AD2:AD19	AD2	=TEXT(N2,"MMM")
AE2:AE19	AE2	=Y2-AG2
AF2:AF19	AF2	=IF(AE2/365<0,"-",AE2/365)
AG2:AG19	AG2	=IF(ISERROR(DATE(DAY(M2),MONTH(M2),YEAR(M2))),L2,M2)
AH2:AH19	AH2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2)))," ",N2)

Cells with Data Validation
Cell	Allow	Criteria
A21	List	=$N$22:$N$29
B21	List	=$O$22:$O$33

 

[maxim642]

Cells A21 & B21 are the selectable dropdowns.

The intention is for the user to be able to select a time period using the dropdowns and then rows 23 onwards will become populated with the leavers for that month/year.

 

[maxim642]

For example, if the user inputs "2020" in A21 & "Sep" in B21, x2 records would pull through (column N determines when the employee has left).

 

[Fluff]

What should go in the Month column?

 

[maxim642]

It could either be the month from column AD or B21.

 

[Fluff]

Ok how about
The headers in A22:K22 must be an exact match with the relevat header in row 1

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Full Name	Employee Number	Job Title	Job Level	Salary	Company	Division	Department	Status	Employee Type	Manager Full Name	Start Date	Continuous Start Date	Leaving Date	Location	Gender	Email	Contract End Date	Standard Hours	Disabled	Car Allowance	Actual FTE	Cost Centre	Ethnicity	LoS Date	Full Time Y/N	Start Year	Start Month	Leave Year	Leave Month	LoS (Days)	Los (Years)	Actual Start Date	Formatted Leave Date
2	Worker 1	1	JT1	JL1	50k	X	Test 1	Dep 1	Current	Employee	Man 1	13/01/2011		13/05/2015	London	Male	test1		37.5	No	0	1	cc1	White - Any other background	13/05/2015	Yes	2011	Jan	2015	May	1581	4.3	40556	42137
3	Worker 2	2	JT2	JL2	50k	X	Test 2	Dep 2	Current	Employee	Man 2	01/03/2019			London	Male	test2			No	0	1	cc2	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2019	Mar			731	2.0	43525
4	Worker 3	3	JT3	JL3	50k	X	Test 3	Dep 3	Current	Employee	Man 3	11/01/2021			London	Male	test3			No	0	1	cc3	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2021	Jan			49	0.1	44207
5	Worker 4	4	JT4	JL4	50k	X	Test 4	Dep 4	Former	Employee	Man 4	01/01/2012		15/07/2020	London	Male	test4		37.5	No	0	1	cc4	White - English, Welsh, Scottish, Northern Irish, British	15/07/2020	Yes	2012	Jan	2020	Jul	3118	8.5	40909	44027
6	Worker 5	5	JT5	JL5	50k	X	Test 5	Dep 5	Current	Employee	Man 5	04/01/2021			London	Female	test5			No	0	1	cc5	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2021	Jan			56	0.2	44200
7	Worker 6	6	JT6	JL6	50k	X	Test 6	Dep 6	Current	Employee	Man 6	30/09/2019			Milton Keynes	Male	test6			No	0	1	cc6		01/03/2021	Yes	2019	Sep			518	1.4	43738
8	Worker 7	7	JT7	JL7	50k	X	Test 7	Dep 7	Current	Employee	Man 7	16/01/2014			London	Male	test7		37.5	No	0	1	cc7	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2014	Jan			2601	7.1	41655
9	Worker 8	8	JT8	JL8	50k	X	Test 8	Dep 8	Former	Employee	Man 8	03/03/1986		30/09/2020	Home	Male	test8			No	0	1	cc8		30/09/2020	Yes	1986	Mar	2020	Sep	12630	34.6	31474	44104
10	Worker 9	9	JT9	JL9	50k	X	Test 9	Dep 9	Former	Employee	Man 9	01/09/2020	30/09/2019	25/09/2020	Home Based	Male	test9			No	0	1	cc9	White - English, Welsh, Scottish, Northern Irish, British	25/09/2020	Yes	2019	Sep	2020	Sep	361	1.0	43738	44099
11	Worker 10	10	JT10	JL10	50k	X	Test 10	Dep 10	Current	Employee	Man 10	06/08/2012			London	Male	test10		37.5	No	0	1	cc10	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2012	Aug			3129	8.6	41127
12	Worker 11	11	JT11	JL11	50k	X	Test 11	Dep 11	Current	Employee	Man 11	09/09/2019		29/02/2016	London	Male	test11		37.5	No	0	1	cc11	White - English, Welsh, Scottish, Northern Irish, British	29/02/2016	Yes	2019	Sep	2016	Feb	-1288	-	43717	42429
13	Worker 12	12	JT12	JL12	50k	X	Test 12	Dep 12	Current	Employee	Man 12	21/05/2018		20/08/2018	London	Female	test12			No	0	1	cc12		20/08/2018	Yes	2018	May	2018	Aug	91	0.2	43241	43332
14	Worker 13	13	JT13	JL13	50k	X	Test 13	Dep 13	Current	Employee	Man 13	03/12/2018			London	Male	test13		37.5	No	0	1	cc13	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2018	Dec			819	2.2	43437
15	Worker 14	14	JT14	JL14	50k	X	Test 14	Dep 14	Current	Employee	Man 14	01/04/2003	01/04/2003		Telford	Female	test14		37.5	No	0	1	cc14	Chinese - British	01/03/2021	Yes	2003	Apr			6544	17.9	37712
16	Worker 15	15	JT15	JL15	50k	X	Test 15	Dep 15	Former	Employee	Man 15	01/05/2012		01/07/2019	London	Male	test15		37.5	No	0	1	cc15	White - English, Welsh, Scottish, Northern Irish, British	01/07/2019	Yes	2012	May	2019	Jul	2617	7.2	41030	43647
17	Worker 16	16	JT16	JL16	50k	X	Test 16	Dep 16	Current	Employee	Man 16	02/04/2019	02/04/2019		London	Male	test16		37.5	No	0	1	cc16	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2019	Apr			699	1.9	43557
18	Worker 17	17	JT17	JL17	50k	X	Test 17	Dep 17	Current	Employee	Man 17	07/09/2020			London	Male	test17			No	0	1	cc17	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2020	Sep			175	0.5	44081
19	Worker 18	18	JT18	JL18	50k	X	Test 18	Dep 18	Current	Employee	Man 18	01/12/2013		08/07/2021	London	Male	test18		37.5	No	0	1	cc18	White - English, Welsh, Scottish, Northern Irish, British	08/07/2021	Yes	2013	Dec	2021	Jul	2776	7.6	41609	44385
20
21	2020	Sep
22	Leave Month	Full Name	Company	Department	Division	Location	Job Title	Start Date	Leaving Date	LoS (Years)	Employee Type			2015	Jan
23	Sep	Worker 8	X	Dep 8	Test 8	Home	JT8	03/03/1986	30/09/2020	34.6	Employee			2016	Feb
24	Sep	Worker 9	X	Dep 9	Test 9	Home Based	JT9	01/09/2020	25/09/2020	1.0	Employee			2017	Mar
25														2018	Apr
26														2019	May
27														2020	Jun
28														2021	Jul
29														2022	Aug
30															Sep
31															Oct
32															Nov
33															Dec
List

Cell Formulas
Range	Formula
Y2:Y19	Y2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2))),TODAY(),N2)
Z2:Z19	Z2	=IF(V2>=1,"Yes","No")
AA2:AA19	AA2	=TEXT(AG2,"YYYY")
AB2:AB19	AB2	=TEXT(AG2,"MMM")
AC2:AC19	AC2	=TEXT(N2,"YYYY")
AD2:AD19	AD2	=TEXT(N2,"MMM")
AE2:AE19	AE2	=Y2-AG2
AF2:AF19	AF2	=IF(AE2/365<0,"-",AE2/365)
AG2:AG19	AG2	=IF(ISERROR(DATE(DAY(M2),MONTH(M2),YEAR(M2))),L2,M2)
AH2:AH19	AH2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2)))," ",N2)
A23:K24	A23	=SORTBY(FILTER(FILTER(A2:AH19,(N2:N19>=DATE(A21,MONTH(B21&1),1))*(N2:N19<DATE(A21,MONTH(B21&1)+1,1))),ISNUMBER(MATCH(A1:AH1,A22:K22,0))),MATCH(COLUMN(A22:K22),{10,1,3,5,4,9,2,7,8,11,6},0),1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A21	List	=$N$22:$N$29
B21	List	=$O$22:$O$33

 

[maxim642]

Ok how about
The headers in A22:K22 must be an exact match with the relevat header in row 1

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Full Name	Employee Number	Job Title	Job Level	Salary	Company	Division	Department	Status	Employee Type	Manager Full Name	Start Date	Continuous Start Date	Leaving Date	Location	Gender	Email	Contract End Date	Standard Hours	Disabled	Car Allowance	Actual FTE	Cost Centre	Ethnicity	LoS Date	Full Time Y/N	Start Year	Start Month	Leave Year	Leave Month	LoS (Days)	Los (Years)	Actual Start Date	Formatted Leave Date
2	Worker 1	1	JT1	JL1	50k	X	Test 1	Dep 1	Current	Employee	Man 1	13/01/2011		13/05/2015	London	Male	test1		37.5	No	0	1	cc1	White - Any other background	13/05/2015	Yes	2011	Jan	2015	May	1581	4.3	40556	42137
3	Worker 2	2	JT2	JL2	50k	X	Test 2	Dep 2	Current	Employee	Man 2	01/03/2019			London	Male	test2			No	0	1	cc2	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2019	Mar			731	2.0	43525
4	Worker 3	3	JT3	JL3	50k	X	Test 3	Dep 3	Current	Employee	Man 3	11/01/2021			London	Male	test3			No	0	1	cc3	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2021	Jan			49	0.1	44207
5	Worker 4	4	JT4	JL4	50k	X	Test 4	Dep 4	Former	Employee	Man 4	01/01/2012		15/07/2020	London	Male	test4		37.5	No	0	1	cc4	White - English, Welsh, Scottish, Northern Irish, British	15/07/2020	Yes	2012	Jan	2020	Jul	3118	8.5	40909	44027
6	Worker 5	5	JT5	JL5	50k	X	Test 5	Dep 5	Current	Employee	Man 5	04/01/2021			London	Female	test5			No	0	1	cc5	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2021	Jan			56	0.2	44200
7	Worker 6	6	JT6	JL6	50k	X	Test 6	Dep 6	Current	Employee	Man 6	30/09/2019			Milton Keynes	Male	test6			No	0	1	cc6		01/03/2021	Yes	2019	Sep			518	1.4	43738
8	Worker 7	7	JT7	JL7	50k	X	Test 7	Dep 7	Current	Employee	Man 7	16/01/2014			London	Male	test7		37.5	No	0	1	cc7	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2014	Jan			2601	7.1	41655
9	Worker 8	8	JT8	JL8	50k	X	Test 8	Dep 8	Former	Employee	Man 8	03/03/1986		30/09/2020	Home	Male	test8			No	0	1	cc8		30/09/2020	Yes	1986	Mar	2020	Sep	12630	34.6	31474	44104
10	Worker 9	9	JT9	JL9	50k	X	Test 9	Dep 9	Former	Employee	Man 9	01/09/2020	30/09/2019	25/09/2020	Home Based	Male	test9			No	0	1	cc9	White - English, Welsh, Scottish, Northern Irish, British	25/09/2020	Yes	2019	Sep	2020	Sep	361	1.0	43738	44099
11	Worker 10	10	JT10	JL10	50k	X	Test 10	Dep 10	Current	Employee	Man 10	06/08/2012			London	Male	test10		37.5	No	0	1	cc10	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2012	Aug			3129	8.6	41127
12	Worker 11	11	JT11	JL11	50k	X	Test 11	Dep 11	Current	Employee	Man 11	09/09/2019		29/02/2016	London	Male	test11		37.5	No	0	1	cc11	White - English, Welsh, Scottish, Northern Irish, British	29/02/2016	Yes	2019	Sep	2016	Feb	-1288	-	43717	42429
13	Worker 12	12	JT12	JL12	50k	X	Test 12	Dep 12	Current	Employee	Man 12	21/05/2018		20/08/2018	London	Female	test12			No	0	1	cc12		20/08/2018	Yes	2018	May	2018	Aug	91	0.2	43241	43332
14	Worker 13	13	JT13	JL13	50k	X	Test 13	Dep 13	Current	Employee	Man 13	03/12/2018			London	Male	test13		37.5	No	0	1	cc13	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2018	Dec			819	2.2	43437
15	Worker 14	14	JT14	JL14	50k	X	Test 14	Dep 14	Current	Employee	Man 14	01/04/2003	01/04/2003		Telford	Female	test14		37.5	No	0	1	cc14	Chinese - British	01/03/2021	Yes	2003	Apr			6544	17.9	37712
16	Worker 15	15	JT15	JL15	50k	X	Test 15	Dep 15	Former	Employee	Man 15	01/05/2012		01/07/2019	London	Male	test15		37.5	No	0	1	cc15	White - English, Welsh, Scottish, Northern Irish, British	01/07/2019	Yes	2012	May	2019	Jul	2617	7.2	41030	43647
17	Worker 16	16	JT16	JL16	50k	X	Test 16	Dep 16	Current	Employee	Man 16	02/04/2019	02/04/2019		London	Male	test16		37.5	No	0	1	cc16	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2019	Apr			699	1.9	43557
18	Worker 17	17	JT17	JL17	50k	X	Test 17	Dep 17	Current	Employee	Man 17	07/09/2020			London	Male	test17			No	0	1	cc17	White - English, Welsh, Scottish, Northern Irish, British	01/03/2021	Yes	2020	Sep			175	0.5	44081
19	Worker 18	18	JT18	JL18	50k	X	Test 18	Dep 18	Current	Employee	Man 18	01/12/2013		08/07/2021	London	Male	test18		37.5	No	0	1	cc18	White - English, Welsh, Scottish, Northern Irish, British	08/07/2021	Yes	2013	Dec	2021	Jul	2776	7.6	41609	44385
20
21	2020	Sep
22	Leave Month	Full Name	Company	Department	Division	Location	Job Title	Start Date	Leaving Date	LoS (Years)	Employee Type			2015	Jan
23	Sep	Worker 8	X	Dep 8	Test 8	Home	JT8	03/03/1986	30/09/2020	34.6	Employee			2016	Feb
24	Sep	Worker 9	X	Dep 9	Test 9	Home Based	JT9	01/09/2020	25/09/2020	1.0	Employee			2017	Mar
25														2018	Apr
26														2019	May
27														2020	Jun
28														2021	Jul
29														2022	Aug
30															Sep
31															Oct
32															Nov
33															Dec
List

Cell Formulas
Range	Formula
Y2:Y19	Y2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2))),TODAY(),N2)
Z2:Z19	Z2	=IF(V2>=1,"Yes","No")
AA2:AA19	AA2	=TEXT(AG2,"YYYY")
AB2:AB19	AB2	=TEXT(AG2,"MMM")
AC2:AC19	AC2	=TEXT(N2,"YYYY")
AD2:AD19	AD2	=TEXT(N2,"MMM")
AE2:AE19	AE2	=Y2-AG2
AF2:AF19	AF2	=IF(AE2/365<0,"-",AE2/365)
AG2:AG19	AG2	=IF(ISERROR(DATE(DAY(M2),MONTH(M2),YEAR(M2))),L2,M2)
AH2:AH19	AH2	=IF(ISERROR(DATE(DAY(N2),MONTH(N2),YEAR(N2)))," ",N2)
A23:K24	A23	=SORTBY(FILTER(FILTER(A2:AH19,(N2:N19>=DATE(A21,MONTH(B21&1),1))*(N2:N19<DATE(A21,MONTH(B21&1)+1,1))),ISNUMBER(MATCH(A1:AH1,A22:K22,0))),MATCH(COLUMN(A22:K22),{10,1,3,5,4,9,2,7,8,11,6},0),1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A21	List	=$N$22:$N$29
B21	List	=$O$22:$O$33

Great job! This is working perfectly. Thank you so much. Have a great evening!

 

[Fluff]

You're welcome & thanks for the feedback.