Hi everyone! I need some assistance with this. I am trying to concatenate 2 constant filtering items. I have a form students fill out every morning, to let me know they are present. As students sign-in, their name automatically filters out of row C and into row B. Everthing works great as it is now, would simply like to add more info to the filtering. If you look at the attachment, row A is a master list which is text only. I want to have the filters in B & C to include their first names in row D (not shown) also, but can not figure it out. Concatenating is easy for cells with simple text, but doing it with filters I have a problem with. Below are my equations, AM and PM are class sessions:
Row B: =UNIQUE(FILTER(F2:F,D2:D>=DATEVALUE(TODAY()),H2:H="AM"))
Row C: =filter(A2:A,len(A2:A),iserror(match(A2:A,B2:B,0)))
I do not want to use VBA if possible.
Thanks in advance!
Row B: =UNIQUE(FILTER(F2:F,D2:D>=DATEVALUE(TODAY()),H2:H="AM"))
Row C: =filter(A2:A,len(A2:A),iserror(match(A2:A,B2:B,0)))
I do not want to use VBA if possible.
Thanks in advance!