跳格取不重複 與下一格總和 (14123)

G3{=INDIRECT(TEXT(MIN(IF((COUNTIF(G$2:G2,A$2:E$98)=0)*MOD(ROW($1:$97),2),ROW($2:$98)/1%+{1,2,3,4,5})),"!R0C00"),)&""

H3=IF(G3="","",SUMIF(A$2:E$98,G3,A$3:E$99))



留言