表格中如何将两列数据做对比,比如A列有4个5,6个3 B列与3个5,8个3,如...答:假设A、B列的数据在区间:A2:A32、B2:B32,在C2单元格输入公式:=IF(COUNTIF($A$2:$A$32,A2)>=COUNTIF($B$2:$B$32,A2),IF(COUNTIF($A$1:A2,A2)>COUNTIF($B$2:$B$32,A2),"A列"&A2&"落单",""),"")&IF(COUNTIF($B$2:$B$32,B2)>=COUNTIF($A$2:$A$32,B2),IF...