creating a selection list out of variable criteria

Hi,
I need help for a problem which should get solved by a formula based solution. Hopefully :-)
I want to create a list of students being absent at the last date I recorded and show this date separately without applying an auto filter. (see attachment)
I didn’t get it with MATCH or INDEX formula:-(
Hope someone can help me…