Hello,
I have the following table:
Name Dates
Student1 2.2.2016 5.2.2016 18.2.2016
Student2 5.2.2016 6.2.2016 8.2.2016 16.2.2016 29.2.2016
Student3 4.2.2016 6.2.2016 16.2.2016 18.2.2016
etc.
I`m searching for a way to find who attended an a particular day i enter. for example:
date i enter: 6.2.2016
result generated:
Student2
Student3
etc.
Is it possible to do this in excel?
Thank you
Bookmarks