Pulling a list from a rota

[Mrs T]

Hi,
I have a monthly rota that I need to create daily lists from.
The table is simple with staff names and day of the month as the axis. There are several shifts they could be working that are abbreviated in each cell.
I currently create daily sheets as a print out by filtering each dy and cutting and pasting names. I'd love to do this by formula to work smarter.
So what could i use if I want to create a list of everyone with either an E, EH, or EL in column B for example?

 

[KRice]

One of the easier ways to do this would be to introduce a column heading (here I've called it "Types") and turn on the column Autofilter...then select whichever types you'd like to display using the dropdown selector. The XL2BB add-in doesn't show this autofilter, but see the snapshot below. To turn the filter on, used Data > Filter.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Calendar Start Wk	1/1/2023
2		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu
3		12/26	12/27	12/28	12/29	12/30	12/31	1/1	1/2	1/3	1/4	1/5
4		Types	Types	Types	Types	Types	Types	Types	Types	Types	Types	Types
5	Mickey Mouse	LH	DO	DO	MD	L	E	DO	AL	AL	10-6	MD
6	Minnie Mouse	DO	DO	E	LH	E	L	E	DO	MDT	E	L
7	Donald Duck	DO	DO	DO	E	DO	L	E	AL	DO	DO	DO
8	Goofy	E	E	10-6	E	DO	DO	L	E	L	LH	E
9	Daisy Duck	N	DO	DO	DO	EL	E	DO	DO	EL	E	DO
10	Pluto	DO	L	DO	N	N	DO	DO	DO	DO	DO	N
11	Lilo	E	L	DO	LI	DO	DO	E	E	DO	DO	DO
12	Simba	DO	E	L	DO	DO	N	N	DO	DO	DO	L
13	Pumba	DO	N	N	DO	DO	DO	DO	AL	AL	AL	DO
14	Timone	EL	DO	DO	DO	AL	DO	DO	N	N	N	DO
15	Grumpy	DO	EL	DO	EL	DO	DO	DO	AL	AL	DO	DO
16	Sleepy	DO	DO	DO	L	E	E	DO	L	E	E	L
17	Happy	S	DO	DO	DO	DO	N	N	DO	DO	DO	S
18	Doc	DO	DO	E	E	E	L	DO	DO	DO	DO	L
19	Sneezy	DO	EL	EL	DO	S	DO	DO	S	DO	S	S
20	Dopey	N	N	AL	AL	AL	DO	DO	AL	AL	AL	AL
21	Bashful	DO	DO	N	N	N	DO	DO	N	N	DO	DO
22	Snow White	S	S	S	DO	DO	DO	DO	S	S	S	DO
Sheet2

Cell Formulas
Range	Formula
B2:AJ2	B2	=B3#
B3:AJ3	B3	=B1-WEEKDAY(B1,3)+SEQUENCE(,35,0)
Dynamic array formulas.

...with EL, E, and LH selected for Monday 12/26:

Book1
	A	B	C	D
1	Calendar Start Wk	1/1/2023
2		Mon	Tue	Wed
3		12/26	12/27	12/28
4		Types	Types	Types
5	Mickey Mouse	LH	DO	DO
8	Goofy	E	E	10-6
11	Lilo	E	L	DO
14	Timone	EL	DO	DO
23
Sheet2

Cell Formulas
Range	Formula
B2:AJ2	B2	=B3#
B3:AJ3	B3	=B1-WEEKDAY(B1,3)+SEQUENCE(,35,0)
Dynamic array formulas.