表格里如何做每期遗漏数值，麻烦大神告知公式，万分感谢

D2=IF(AND(B2<>B3,B2>0),COUNTIF(B$2:B2,B2)-SUM(C$1:C1),"")

E2=IF(AND(A2<>A3,A2>0),COUNTIF(A$2:A2,A1)-SUM(D$1:D1),"")

G2=IFERROR(INDEX(FREQUENCY(IF(表1!$C$2:$C$19<>G$1,ROW($1:$18)),IF(表1!$C$2:$C$19=G$1,ROW($1:$18))),ROW(G1)),"")

数组公式，右拉下拉

数据范围配合实际范围修改

G2=IFERROR(INDEX(FREQUENCY(IF(OFFSET(表1!$C$2,,,COUNT(表1!$C:$C))<>G$1,ROW(INDIRECT("1:"&COUNT(表1!$C:$C)))),IF(OFFSET(表1!$C$2,,,COUNT(表1!$C:$C))=G$1,ROW(INDIRECT("1:"&COUNT(表1!$C:$C))))),ROW(G1)),"")

数据范围不限

---