累計數 依對照表找类型 (9973)

 

 D2{=OFFSET(H$1,MATCH(1,(G$2:G$38=B2)*(SUMIF(B$2:B2,B2,C$2:C2)<=SUMIF(OFFSET(G$2,,,ROW($1:$37)),G$2:G$38,OFFSET(I$2,,,ROW($1:$37)))),),)