E2公式输入之后怎么变成0了,出不来安吉线 啊
E2数组公式,输入完成后不要直接回车,要按三键 CTRL+SHIFT+回车 结束右拉再下拉:
=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$999&$B$2:$B$999&$C$2:$C$999,$A$2:$A$999&$B$2:$B$999&$C$2:$C$999,)=ROW($1:$998),ROW($2:$999),4^8),ROW(A1)))&""
H2公式下拉:
=IF(E2="","",SUMPRODUCT(N(E2&F2&G2=$A$2:$A$999&$B$2:$B$999&$C$2:$C$999)))
我把文件传上来,请点击这回答右下角绿色的“点击下载”按钮,下载文件看看效果。