Generating Class Lists from Schedule

[nerickson6]

I'm trying to generate class lists automatically from the 'student individual schedule' tab in the 'class lists' tab. I can't seem to wrap my head around how to set up a lookup function to generate it. Any help would be super duper appreciated!

[AliGW]

I'm afraid I don't have time to do it for you this morning, as I'm about to go out, but see if you can adapt the attached demo sheet. It extracts a list for a section from a master list. It uses two array formulae entered using CTRL+SHIFT+ENTER (don't try to type the curly brackets yourself, as it won't work).

Master List:

Employee Code Surname Site
FF-01 Smith YB-Section
FF-02 Jones YB-Section
FF-03 Baker YB-Section
FF-04 Henry YB-Section
FF-05 Wright YB-Section
FF-06 Matthews YB-Section
FF-07 Richards YB-Section
FF-08 Penty XA-Section
FF-09 Wood XA-Section
FF-10 Barnes XA-Section
FF-11 Du Toit XA-Section
FF-12 Encinas VT-Section
FF-13 Mann VT-Section
FF-14 Cook VT-Section
FF-15 Stone VT-Section

Extracted List:

XA-Section
FF-08 Penty
FF-09 Wood
FF-10 Barnes
FF-11 Du Toit

ARRAY FORMULA (can be copied down and across):

=IFERROR(INDEX(A:A,SMALL(IF($C$2:$C$21=$K$1,ROW($A$2:$A$21)),ROWS($A$1:A1))),"")

See attachment for details.

[micope21]

Hi

You can use Aggregate if you are on excel 2010, 2013 or 2016? But won't work if you on 2007 or 2003!!

Sheet Class List
Cell A3

Please Login or Register  to view this content.

Enter then copy down and cross to Grade columns

B3

Please Login or Register  to view this content.

Enter then copy down and cross to Students columns

[nerickson6]

Thank you both a ton for your help. Both good suggestions.

[AliGW]

You're welcome!