如何在Excel中设定条件引用公式以实现多列数据自动引用答:AB6 =IF(AND(COLUMN()<=MIN(IF(ISNUMBER(FIND($B6,$1:$1)),COLUMN($1:$1),""))+6,COLUMN()>=MIN(IF(ISNUMBER(FIND($B6,$1:$1)),COLUMN($1:$1),""))),INDIRECT(ADDRESS(ROW(),MOD(COLUMN(A1)-1,7)+1)),"") 复制公式至AB6按组合键ctrl+shift+enter结束公式输入,下...