Excel公式问题:INDEX公式怎么筛选两个条件?答:INDEX公式筛选两个条件,可以用下面的方法:原公式是=IFERROR(INDEX(D:D,SMALL(IF($B:$B=G3,ROW($1:$10000)),ROW(A1))),0)。修改为=IFERROR(INDEX(D:E,SMALL(IF($B:$B&$C:$C=G3&H3,ROW($1:$10000),4^8),ROW(B1)),{1,2}),"")数组公式,低版本需要三键CTRL+SHIFT+ENTER...
excel中如何在一个数组中挑选出某些下标,在一个单元格中显示出来?_百 ...答:=INDEX({"这","是","一","个","数","组"},1)&INDEX({"这","是","一","个","数","组"},3)&INDEX({"这","是","一","个","数","组"},5)office365用如下公式 =INDEX({"这","是","一","个","数","组"},{1,3,5})但结果不在同一单元格 ...