G5=TEXT(MIN(H$2-SUM(OFFSET(F$1,LOOKUP(1,0/(E$5:E5="A"),ROW($4:4)),,ROW()-LOOKUP(1,0/(E$5:E5="A"),ROW($4:4))))+F5,F5),"0;;")
另解{=TEXT(MIN(H$2-SUM(F$5:F5)+SUM((COUNTIF(OFFSET(E$5,,,ROW($1:$11)),"A")<COUNTIF(E$5:E5,"A"))*F$5:F$15)+F5,F5),"0;;")
另解 G5{=TEXT(MIN(F5,COUNTIF(E$5:E5,"A")*H$2-SUM(IFERROR(G$4:G4*1,))),"0;;")
留言
張貼留言