The info at the www.contextures.com site is applicable and can be
adapted to your project.
Maybe this slightly different, customized approach will help you:
Open workbook with 2 sheets: Students, Bullets
On sheet Students:
Enter student names in a column named Student
Create an equal sized column named Attribute
EditGotoAttributeDataValidationSource: =Att_Check
InsertNameDefineNames in workbook: Att_Check Refers to
=OFFSET(INDEX(Remains1,1),0,0,COUNTA(Remains1)-COUNTBLANK(Remains1),1)
On sheet Bullets:
Enter bullet attributes in a column and name it Attr1.
Create two columns of the size of Attr1 and name them Used1 and
Remains1
Enter this formula into Used1:
=IF(COUNTIF(Attribute,Attr1 R)=1,"",
ROW(Attr1 R)-ROW(INDEX(Attr1,1))+1)
Enter this array formula into Remains1:
=IF((ROW(Attr1)-ROW(Attr1 R)+1)COUNT(Used1),"",
INDEX(Attr1,SMALL(Used1,ROW(Attr1)-ROW(Attr1 R)+1)))
Expand project by creating more bullet sheets and creating new names.