I want the list on D10 and on to show me who was here by the day i put on D9. For example: I wrote on D9 "Sunday" so it should scan the "Sunday" list on O10 and give me Students 1,2,4,5 on D1013 because Student number 3 was not here. (D14 should stay empty)
This question has been posted in at least one other forum. Do not post any further responses in this thread until a link has been provided to these cross posts.
Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184
This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere. Please update your original post to include the link(s).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.