Attendance lookup table

[azeera]

Can anyone help me tp solve my problem. I have a list of attendance of my student. How can i sort the data with the value of total student absent/present and list the name of absent student with the specific date.

I'm trying to find a way to take the specific date in excel doc and list down the name of student which is in absent.

Attachment 698231

Attached is an example file.

Under the "LOOKUP" tab is the total sutdent in my class.
Under the "RAW" tab is the original data that i have from microsoft forms.
Under the DATABASE" is the sheet that i need to modified to get the value.

Does anybody have any ideas?

[vba_php]

you talk about wanting to capture the ""absent"' dates. however, you have nothing in the "total absent" column, nor the "total present" column. how is excel supposed to give you summary data about these two points if it has nothing to go off of? like a log of the days every student was absent??

on a side note, is this you?

https://en.wikipedia.org/wiki/MARA_J...itute_Beranang

if so, it looks like you're training people well for jobs of the future.

[Logit]

.
The ATTACHMENT link is dead.

???

[azeera]

Sorry i hv to rearrange my data back to make it complete

[azeera]

its true...but in excel im just a beginner