日期排序 並重複顯示值 (14453)

E2:F18=IF(ROW(A1)>SUM($C:$C),"",INDEX(B:B,LOOKUP(1,0/FREQUENCY(ROW(A1),SUMIF($B:$B,"<="&$B$2:$B$6,$C:$C)),ROW($2:$7))))



留言