excel多条件自动分类填充答:E2=LOOKUP("座",A$2:A2)&B2&IF(ISERROR(VLOOKUP(D2,D3:E13,2,)),"",","&VLOOKUP(D2,D3:E13,2,))向下复制 J2=INDEX(D:D,MIN(IF(COUNTIF(J$1:J1,$D$2:$D$13),4^8,ROW($D$2:$D$13)))&""数组公式向下复制【数组公式,公式输完后,光标放在公式编辑栏同时按下CTRL+SHIF...
Excel多条件填充数据?答:=IF(B2>=5,"小螺旋晒图",IF(B2>=3,"动销10笔",IF(OR(AND(B2=2,A2>=10),AND(B2=1,A2>=20),AND(B2=0,A2>=30)),"动销5笔",IF(OR(AND(B2=2,A2<10),AND(B2=1,A2>=10),AND(B2=0,A2>=20)),"动销3笔",IF(AND(B2=1,A2<10),"不加特","")))回车并向下填充。另,...
EXCEL表格中某一单元格如何实现同时满足2个及以上条件后自动填充相应...答:E3=offset(sheet1!$A$1,match($B$1,sheet1!B:B,0)-1,match($C$3,sheet1!$G$4:$I$4,0)+5)E4=offset(sheet1!$A$1,match($B$1,sheet1!B:B,0)-1,match($C$3,sheet1!$J$4:$L$4,0)+8)假设你汇总表为sheet1