如何用if语句实现给数据分段答:假设你的数据在A列,从A2开始,你可以在B2单元格输入以下公式: =IF(A2<=10,"0-10",IF(A2<=20,"10-20",IF(A2<=30,"20-30",IF(A2<=40,"30-40",IF(A2<=50,"40-50",IF(A2<=60,"50-60",IF(A2<=70,"60-70",IF(A2<=80,"70-80",IF(A2<=90,"80-90","90-100"))...
EXCEL怎么把多行数据以第一列为准,分成两列?答:G2输入 =INDEX($A$1:$A$100,SMALL(IF(COUNTIF(OFFSET($B$1:$F$1,ROW($1:$100)-1,),"<>")>=COLUMN(A:Y),ROW($1:$100)),ROW(A1)))同时按下CTRL+SHIFT+Enter三键,使数组公式出现{ },公式下拉 H2输入 =VLOOKUP(G2,A:E,COUNTIF(G$2:G2,G2)+1,) 公式下拉 ...