EXCEL汇总前几个表的内容?答:汇总表中,先把B列名称复制好,然后=LEFT(IFERROR(VLOOKUP($B6,Sheet5!$B:$E,COLUMN()-1,FALSE)&"@","")&IFERROR(VLOOKUP($B6,Sheet4!$B:$E,COLUMN()-1,FALSE)&"@","")&IFERROR(VLOOKUP($B6,Sheet3!$B:$E,COLUMN()-1,FALSE)&"@","")&IFERROR(VLOOKUP($B6,Sheet2!$B:$...
Excel的问题答:先升序排列原表,然后用筛选公式筛选。如图所示(数组公式,按ctrl+shift+enter产生花括号):=IFERROR(INDEX(J$1:J$999,SMALL(IF(L$1:L$999=B$1,ROW($1:$999),4^8),ROW(A1))),"")=IFERROR(INDEX(M$1:M$999,SMALL(IF(L$1:L$999=B$1,ROW($1:$999),4^8),ROW(A1))),""...