|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 我走我流 于 2018-12-12 12:57 编辑
D2=IF(COUNT(FIND(0,$A2:$C2))=3,0,"")&SUBSTITUTE(SUM(IF(MMULT(N(ISNUMBER(FIND(ROW($1:$9),$A2:$C2))),ROW(1:3)^0)=3,ROW($1:$9))*10^(9-ROW($1:$9))),0,"")数组下拉
E2:G2=IF(COUNT(FIND(0,IF({1,0},A2,$D2)))=1,0,"")&SUBSTITUTE(SUM(IF(MMULT(N(ISERR(FIND(ROW($1:$9),IF({1,0},A2,$D2)))),ROW(1:2)^0)=1,ROW($1:$9))*10^(9-ROW($1:$9))),0,"")数组右下拉
H2=IF(COUNT(FIND(0,$E2:$G2))=2,0,"")&SUBSTITUTE(SUM(IF(MMULT(N(ISNUMBER(FIND(ROW($1:$9),$E2:$G2))),ROW(1:3)^0)>=2,ROW($1:$9))*10^(9-ROW($1:$9))),0,"")数组下拉
I2==IF(COUNT(FIND(0,IF({1,0},D2,$H2))),"",)&SUBSTITUTE(SUM(IF(MMULT(N(ISNUMBER(FIND(ROW($1:$9),IF({1,0},D2,$H2)))),ROW(1:2)^0)=0,ROW($1:$9))*10^(9-ROW($1:$9))),0,"")数组下拉
|
|