Attendance list on a particular date
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
Array Index to get a conditional list
Hi,
an attempt
In A2:A100 names
in B2:F100 dates
in G1 date to be processed
In I2:
=IFERROR(INDEX($A$2:$A$100,SMALL(IF(MMULT(--($B$2:$F$100=$G$1),TRANSPOSE(COLUMN(B:F)^0))>0,ROW($2:$100)-1),ROWS($1:1))),"")
This formula must be confirmed with control+shift+enter before to be copied down in order to get the list.
Hope it helps