判別各班別 (12660)

J2:N6{=LOOKUP(1,0/(SUM(IFERROR(SMALL(IF(B$2:B$19=$I2,COUNTIF(OFFSET($A$2,,,ROW($1:$18)),"<>")),{1,2})*{10,1},))={0,10,20,30,12,13,23}),$P$1:$V$1)&""

Q2:V6=COUNTIF($J2:$N2,Q$1)