excel里筛选出区域内符合条件的单元格内容用什么函数?答:E2公式右拉:=INDEX($A:$A,SMALL(IF($B$2:$B$11=-LOOKUP(,-RIGHT(SUBSTITUTE($D2,":",),ROW($1:$9))),ROW($2:$11),4^8),COLUMN(A1)))&""E3公式右拉:=INDEX($A:$A,SMALL(IF($B$2:$B$11>-LOOKUP(,-RIGHT(SUBSTITUTE($D3,":",),ROW($1:$9))),ROW($2:$11...
excel中,如何有条件选择相邻单元格并计算答:在""中的A1单元格输入"陈六",在B1输入公式=if(row(a1)<=countif(总计!b:b,a$1),index(总计!c:c,small(if(match(A$1,总计!B$1:B$100,0)=row($1:$100),row($1:$100),""),row(a1))),"")下拉填充5行以上.