不重複 最後5笔订单 (9753)

F3:F7{=IFERROR(INDEX(OFFSET(B$1,COUNTA(B:B)-5,,5),MATCH(,COUNTIF(F$2:F2,OFFSET(B$1,COUNTA(B:B)-5,,5)),)),"")

G3:G7=IF(F3="","",SUMIF(OFFSET(B$1,COUNTA(B:B)-5,,5),F3,OFFSET(C$1,COUNTA(B:B)-5,,5)))