excel怎么做到自动寻找列出从0000到9999的单数和列出奇数,还有能够自动...答:见截图 B2输入 =INDEX(A:A,SMALL(IF(MOD($A$1:$A$1000,2)=1,ROW($1:$1000),4^8),ROW(A1)))&""数组公式,先按住CTRL+SHIFT,最后回车 公式下拉 C2输入 =INDEX(A:A,SMALL(IF(ISNUMBER(FIND(99,$A$1:$A$1000)),ROW($1:$1000),4^8),ROW(A1)))&""数组公式,先按住CTRL+...
excel返回每行数值为1所对应列名答:如果为高版本,可用textjoin函数,否则F2输入:=IFERROR(LEFT(IF(A2,$A$1&"|","")&IF(B2,$B$1&"|","")&IF(C2,$C$1&"|","")&IF(D2,$D$1&"|","")&IF(E2,$E$1&"|",""),LEN(IF(A2,$A$1&"|","")&IF(B2,$B$1&"|","")&IF(C2,$C$1&"|","")&IF(D2...