彙整每班内容與班总价 (10684)

O2 右拉 下拉 {=INDEX($B:$B,SMALL(IF(ISERR(FIND(","&$N2&",",","&$K$2:$K$9&",")),99,ROW($2:$9)),COLUMN(A1)))&""

U2下拉=SUMPRODUCT(L$2:L$9/(LEN(K$2:$K$9)-LEN(SUBSTITUTE(K$2:K$9,",",))+1)*COUNTIF(O2:S2,B$2:B$9))