E3{=IFERROR(OFFSET(A$2,SMALL(IF(ROUNDUP(IF(MATCH(A$3:A$6,A$3:A$6,)=ROW($1:$4),SUMIF(A$3:A$6,A$3:A$6,B$3:B$6))/VLOOKUP(T(IF({1},A$3:A$6)),A$10:B$12,2,),)>=COLUMN(A:Z),ROW($1:$4)),ROW(A1)),),"")
F3=IF(E3="","",MIN(SUMIF(A$3:A$6,E3,B$3:B$6)-(COUNTIF(E$3:E3,E3)-1)*VLOOKUP(E3,A$10:B$12,2,),VLOOKUP(E3,A$10:B$12,2,)))
留言
張貼留言