excel有两列,第一列有数字我想第二列数字大于10的显示A,大于5小于10...答:=IF(A1>10,"A",IF(A1>5,"B","C"))或 =IF(A1<5,"C",IF(A1<10,"B","A"))或 =IF(A1="","",LOOKUP(A1,{-9E+307,5,10}+10^-8,{"C","B","A"}))下拉填充
excel如何列出第一列中某一序列下在第二列的相应数据。答:D1单元格写入公式 =INDEX(A:A,SMALL(IF(MATCH(A$1:A$20&"",A$1:A$20&"",)=ROW($1:$20),ROW($1:$20),4^8),ROW(A1)))&""数组公式,按下SHIFT+CTRL+ENTER三键,下拉复制公式 E1单元格写入公式 =INDEX($B:$B,SMALL(IF($A$1:$A$20=$D1,ROW($1:$20),4^8),COLUMN(A1)...