EXCEL里面两组数据如何比大小

两组数据是一一对应做比较?
假设你两组数据分别在A列和B列,在C1输入
=IF(A1>B1,"大",IF(A1=B1,"等","小"))
然后在C1:C3输入
=COUNTIF(B:B,"大")
=COUNTIF(B:B,"等")
=COUNTIF(B:B,"小")

下拉即可.
再问： 是一一对应的
再答： C1输入 =IF(A1>B1,"大",IF(A1=B1,"等","小")) 下拉 然后在D1:D3输入 =COUNTIF(C:C,"大") =COUNTIF(C:C,"等") =COUNTIF(C:C,"小")