check this out

[HomeBrewerDude]

=IF(B5="Math",(CONCATENATE(IF((D5>0),D$4,""),", ",IF(E5>0,E$4,""),", ",IF(F5>0,F$4,""),", ",IF(G5>0,G$4,""),", ",IF(H5>0,H$4,""),", ",IF(I5>0,I$4,""))),IF(B5="Science",CONCATENATE(IF(K5>0,K$4,""),", ",IF(L5>0,L$4,""),", ",IF(M5>0,M$4,""),", ",IF(N5>0,N$4,""),", ",IF(O5>0,O$4,""),", ",IF(P5>0,P$4,"")),(CONCATENATE(IF((D5>0),D$4,""),", ",IF(E5>0,E$4,""),", ",IF(F5>0,F$4,""),", ",IF(G5>0,G$4,""),", ",IF(H5>0,H$4,""),", ",IF(I5>0,I$4,""),", ",IF(K5>0,K$4,""),", ",IF(L5>0,L$4,""),", ",IF(M5>0,M$4,""),", ",IF(N5>0,N$4,""),", ",IF(O5>0,O$4,""),", ",IF(P5>0,P$4,"")))))


time for a :beer:

 

[imported_Tick]

What's it do?

 

[dullard]

I do that all the time. Great for giving student's grades.

 

[GeekDrew]

?