20241209求助

流住我

将c列中满足开始行的行为g2的3的值为开始行，h2的9的值为结束行所有的数字和d列d3:d12
比较，找出没有出现的数字7，8,9放到e3:e5，次数为0，放到f3:f5，其他一样，请各位老师在红色部分加上函数，多谢！！

loirol

=VSTACK(MID(SUBSTITUTE(TEXTJOIN("",,ROW($A$1:$A$9)),TEXTJOIN("",,UNIQUE(INDIRECT("C"&$G$2&":C"&$H$2))),""),ROW(INDIRECT("A1:A"&LEN(SUBSTITUTE(TEXTJOIN("",,ROW($A$1:$A$9)),TEXTJOIN("",,UNIQUE(INDIRECT("C"&$G$2&":C"&$H$2))),"")))),1),MID(TEXTJOIN("",,UNIQUE(INDIRECT("C"&$G$2&":C"&$H$2))),ROW(INDIRECT("A1:A"&LEN(TEXTJOIN("",,UNIQUE(INDIRECT("C"&$G$2&":C"&$H$2)))))),1))

=COUNTIF(INDIRECT("C"&$G$2&":C"&$H$2),E3)

格式改xlsx

袁勇

=MOD(AGGREGATE(15,6,COUNTIF(OFFSET(C$1,G$2-1,,H$2-G$2+1),{1;2;3;4;5;6;7;8;9})*100+{1;2;3;4;5;6;7;8;9},ROW(A1)),10)

=COUNTIF(OFFSET(C$1,G$2-1,,H$2-G$2+1),E3)

vic9

1. =SORT(HSTACK(D3:D11,BYROW(N(D3:D11=TRANSPOSE(INDIRECT("C"&G2&":"&"C"&H2))),SUM)),2)

复制代码