Pop up to show employees who are off today

[myletterboxnp]

Hi there,

We have a schedule on excel spreadsheet where my team enters their schedule. B4 has name of employee, c4 has either their duty time eg. 9:00 a.m. or "OFF" if they are off. There are like 20/30 employees (B4 down B30) and their schedule (C4 down C20 let's say). Instead of checking individually who is "OFF", I was thinking of, when someone opens the spreadsheet, a popup screen (that can be closed) that shows all the people who are "OFF" on that day, Is that possible?

 

[JamesCanale]

No pop up, but if you can find a spot for a small table, here are some options.

MrExcelPlayground15.xlsx
	B	C	D	E	F	G
2						People who are off
3	Name	1/10/2023	1/11/2023	1/12/2023		This finds what is in C
4	Fred	9:00	9:00	9:00		Harry
5	Harry	Off	9:00	9:00		Sally
6	Mary	9:00	9:00	9:00
7	Sally	Off	Off	Off		or
8	Johnny	9:00	9:00	Off		This finds what matches Today in row 3
9	Jamie	9:00	9:00	9:00		Sally
10	Nicole	9:00	Off	9:00		Nicole
Sheet9

Cell Formulas
Range	Formula
G4:G5	G4	=FILTER(B4:B10,C4:C10="Off")
G9:G10	G9	=FILTER(B4:B10,INDEX(C4:E10,,MATCH(TODAY(),C3:E3,0))="Off")
Dynamic array formulas.

 

[myletterboxnp]

The second formula did the magic. Thank you kindly!