根据网友的公式，练习一下在E1中输入或复制粘贴下列数组公式=INDIRECT(TEXT(MOD(SMALL(IF(A$1:C$10<>"",COLUMN(A$1:C$10)*10001+ROW(A$1:C$10)/1%),ROW(A1)),10^4),"R0C00"),)或=INDIRECT(TEXT(MOD(SMALL(IF(A$1:C$10<>"",COLUMN($A:$C)*10001+ROW($1:$10)/1%),ROW(A1)),10^4),"R0C00"),)按三键CTRL+SHIFT+ENTER结束输入下拉填充
咩丝忒酷
