C13{=OFFSET(B$13,-MATCH(1=1,SUBTOTAL(9,OFFSET(C$12,,,-ROW($1:$11)))>B13,),)
C13另解=LOOKUP(,0/(SUMIF(B$1:B$12,"<="&B$2:B$12,C$1:C$12)>B13),B$2:B$12)
C13另解=LOOKUP(,0/FREQUENCY(9^-9,SUMIF(B$1:B$12,"<="&B$2:B$12,C$1:C$12)-B13),B$2:B$12)
D2:D12=SUM(C2:C$12)
留言
張貼留言