I need the list of students with only a value of "A" in the date column. Sample is on the Summary sheet. Probably using a Pivot Table for automatic sorting?
I need the list of students with only a value of "A" in the date column. Sample is on the Summary sheet. Probably using a Pivot Table for automatic sorting?
Last edited by KlahrinzC; 08-03-2020 at 04:05 PM.
Hello,
In Summary!A2, then copy down & across.
=IFERROR(INDEX('Raw Attendance'!$A:$A,AGGREGATE(15,6,ROW('Raw Attendance'!$A$2:$A$23)/('Raw Attendance'!B$2:B$23="A"),ROWS(A$2:A2))),"")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
If you have the Filter function, another option would be
In A2 copied across only
=FILTER('Raw Attendance'!$A$2:$A$23,FILTER('Raw Attendance'!$B$2:$C$23,'Raw Attendance'!$B$1:$C$1=A1)="A")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks