Try
in A6
=IFERROR(INDEX('MASTER STUDENT LIST'!F$3:F$500,SMALL(IF(('MASTER STUDENT LIST'!$C$3:$C$500=$B$2)*('MASTER STUDENT LIST'!$D$3:$D$500=$C$2),ROW($A$3:$A$500)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")
Enter with Ctrl+Shift+Enter
Copy across and down
I put Class in B2 and teacher in C2 (of "1-206" tab)
Last edited by JohnTopley; 06-15-2016 at 10:37 AM.
Hi John -
THis is super helpful. I have spent a bit of time on YouTube trying to understand the methodology behind the formula. I inserted rows in the Master sheet in order to accommodate more students. That changed the Master Sheet Index range accordingly. I seem to be running into problems in the outer grades (bottom of the spreadsheet). Check out the 5th grade classrooms....
Thanks for any help in advance
Erin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks