在A列和B列中有OK,NG两种文本,如何在EXCEL中将同一行相等的数目统计出.A列:OK OK NG NG OK OKB列:OK OK NG OK OK NGA,B同为OK:3A,B同为NG:1A为NG,B为ok:1A为OK.B为NG:1如果是A-1\x05A-2\x05A-3\x05B-1\x05B-2\x05B-3\x05C-1
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/22 05:54:29
![在A列和B列中有OK,NG两种文本,如何在EXCEL中将同一行相等的数目统计出.A列:OK OK NG NG OK OKB列:OK OK NG OK OK NGA,B同为OK:3A,B同为NG:1A为NG,B为ok:1A为OK.B为NG:1如果是A-1\x05A-2\x05A-3\x05B-1\x05B-2\x05B-3\x05C-1](/uploads/image/z/5899787-35-7.jpg?t=%E5%9C%A8A%E5%88%97%E5%92%8CB%E5%88%97%E4%B8%AD%E6%9C%89OK%2CNG%E4%B8%A4%E7%A7%8D%E6%96%87%E6%9C%AC%2C%E5%A6%82%E4%BD%95%E5%9C%A8EXCEL%E4%B8%AD%E5%B0%86%E5%90%8C%E4%B8%80%E8%A1%8C%E7%9B%B8%E7%AD%89%E7%9A%84%E6%95%B0%E7%9B%AE%E7%BB%9F%E8%AE%A1%E5%87%BA.A%E5%88%97%EF%BC%9AOK+OK+NG+NG+OK+OKB%E5%88%97%EF%BC%9AOK+OK+NG+OK+OK+NGA%2CB%E5%90%8C%E4%B8%BAOK%3A3A%2CB%E5%90%8C%E4%B8%BANG%3A1A%E4%B8%BANG%2CB%E4%B8%BAok%3A1A%E4%B8%BAOK.B%E4%B8%BANG%3A1%E5%A6%82%E6%9E%9C%E6%98%AFA-1%5Cx05A-2%5Cx05A-3%5Cx05B-1%5Cx05B-2%5Cx05B-3%5Cx05C-1)
在A列和B列中有OK,NG两种文本,如何在EXCEL中将同一行相等的数目统计出.A列:OK OK NG NG OK OKB列:OK OK NG OK OK NGA,B同为OK:3A,B同为NG:1A为NG,B为ok:1A为OK.B为NG:1如果是A-1\x05A-2\x05A-3\x05B-1\x05B-2\x05B-3\x05C-1
在A列和B列中有OK,NG两种文本,如何在EXCEL中将同一行相等的数目统计出.
A列:OK OK NG NG OK OK
B列:OK OK NG OK OK NG
A,B同为OK:3
A,B同为NG:1
A为NG,B为ok:1
A为OK.B为NG:1
如果是
A-1\x05A-2\x05A-3\x05B-1\x05B-2\x05B-3\x05C-1\x05C-2\x05C-3
OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK
OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK
OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK
OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK
OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK\x05OK
OK\x05NG\x05NG\x05NG\x05NG\x05OK\x05NG\x05NG\x05NG
A,B同为NG,OK,A为ok,B为NG,A为NG,B为OK.;
(包括A1=B1,A2=B2,A3=B3)
AC,BC同理
要怎么计算?
好像要插入对照表,
在A列和B列中有OK,NG两种文本,如何在EXCEL中将同一行相等的数目统计出.A列:OK OK NG NG OK OKB列:OK OK NG OK OK NGA,B同为OK:3A,B同为NG:1A为NG,B为ok:1A为OK.B为NG:1如果是A-1\x05A-2\x05A-3\x05B-1\x05B-2\x05B-3\x05C-1
需要加一个辅助列然后用COUNTIF函数
给你上公式,
如图:
辅助列的公式:
=IF(A2="OK",IF(A2=B2,"A","B"),IF(A2=B2,"C","D"))
同OK的公式:
=COUNTIF(C:C,"A")
A-OK,B-NG的公式:
=COUNTIF(C:C,"B")
同NG的公式:
=COUNTIF(C:C,"C")
A-NG,B-OK的公式:
=COUNTIF(C:C,"D")
你需要做怎样的对比?
是A1-B1,A2-B2,A3-B3,还是A1-B2也可以?就是序号是要完全相对的么?