请解读一下=IF(COUNTIF(B:B,A1)=0,A1,"")OFFICE2003里相比较A列与B列的数值,相同的在C列输出0,不同的在C列输出A列对应的数值,为什么利用上面的函数在C列得到的是全部A列的数值?A列 B列ZZ1047C2813C137/D0B-
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/28 20:07:12
![请解读一下=IF(COUNTIF(B:B,A1)=0,A1,](/uploads/image/z/5529109-13-9.jpg?t=%E8%AF%B7%E8%A7%A3%E8%AF%BB%E4%B8%80%E4%B8%8B%3DIF%28COUNTIF%28B%3AB%2CA1%29%3D0%2CA1%2C%22%22%29OFFICE2003%E9%87%8C%E7%9B%B8%E6%AF%94%E8%BE%83A%E5%88%97%E4%B8%8EB%E5%88%97%E7%9A%84%E6%95%B0%E5%80%BC%2C%E7%9B%B8%E5%90%8C%E7%9A%84%E5%9C%A8C%E5%88%97%E8%BE%93%E5%87%BA0%2C%E4%B8%8D%E5%90%8C%E7%9A%84%E5%9C%A8C%E5%88%97%E8%BE%93%E5%87%BAA%E5%88%97%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E5%80%BC%2C%E4%B8%BA%E4%BB%80%E4%B9%88%E5%88%A9%E7%94%A8%E4%B8%8A%E9%9D%A2%E7%9A%84%E5%87%BD%E6%95%B0%E5%9C%A8C%E5%88%97%E5%BE%97%E5%88%B0%E7%9A%84%E6%98%AF%E5%85%A8%E9%83%A8A%E5%88%97%E7%9A%84%E6%95%B0%E5%80%BC%3FA%E5%88%97+B%E5%88%97ZZ1047C2813C137%2FD0B-)
请解读一下=IF(COUNTIF(B:B,A1)=0,A1,"")OFFICE2003里相比较A列与B列的数值,相同的在C列输出0,不同的在C列输出A列对应的数值,为什么利用上面的函数在C列得到的是全部A列的数值?A列 B列ZZ1047C2813C137/D0B-
请解读一下=IF(COUNTIF(B:B,A1)=0,A1,"")
OFFICE2003里相比较A列与B列的数值,相同的在C列输出0,不同的在C列输出A列对应的数值,为什么利用上面的函数在C列得到的是全部A列的数值?
A列 B列
ZZ1047C2813C137/D0B-0490Q17D2035L \x05ZZ1047A3413A1/A0WSX-B
ZZ1047C2813C137/D0B-0490X17D2035L \x05ZZ1047A3414A1/A0WSJ-B
ZZ1047C2813C145/D0B-0490Q17D2035L \x05ZZ1047B2813B1/B0WSQ-B
ZZ1047C2813C145/D0B-0490X17D2035L \x05ZZ1047C3413C145/D0B-0490Q17D2035L
ZZ1047C2813C145/D0W-0490J17D2035L \x05ZZ1047C3413C145/D0B-0490X17D2035L
ZZ1047C2813C145/D0W-0490X17D2035L \x05ZZ1047C3413C145/D0W-0490Q17D2035L
ZZ1047C2814C145/D0B-0490Q17D2035L \x05ZZ1047C3413C145/D0W-0490X17D2035L
ZZ1047C2814C145/D0B-0490X17D2035L \x05ZZ1047C3414B1/C0BSJ-B
ZZ1047C3413C137/F5W-0490X17D2035L \x05ZZ1047C3414B145/C0WUC-B
ZZ1047C3413C145/D0B-0490Q17D2035L \x05ZZ1047C3414C145/D0B-0490Q17D2035L
ZZ1047C3413C145/D0B-0490X17D2035L \x05ZZ1047C3414C145/D0B-0490X17D2035L
ZZ1047C3413C145/D0W-0490Q17D2035L \x05ZZ1047C3414C145/D0W-0490Q17D2035L
ZZ1047C3413C145/D0W-0490X17D2035L \x05ZZ1047C3414C145/D0W-0490Q17D2235L
ZZ1047C3413C145/D0W-0490X17D2235L \x05ZZ1047C3414C145/D0W-0490Q19D2442L
ZZ1047C3413C145/F5B-0490X17D2035L \x05ZZ1047C3414C145/D0W-0490X17D2035L
ZZ1047C3413C145/F5W-0490J17D2035L \x05ZZ1047C3414C145/F5B-0490J17D2035L
ZZ1047C3413C145/F5W-0490X17D2035L \x05ZZ1047C3414C145/F5B-0490X17D2035L
ZZ1047C3414C145/D0B-0490Q17D2035L \x05ZZ1047C3414C145/F5W-0490Q19D2442L
ZZ1047C3414C145/D0B-0490X17D2035L \x05ZZ1047C3414C145/F5W-0490X17D2035L
ZZ1047C3414C145/D0B-0490X17D2235L \x05ZZ1047D3414B1/D0WVN-B
ZZ1047C3414C145/D0W-0490J17D2035L \x05ZZ1047D3414C137/F0B-4100N17D2035L
ZZ1047C3414C145/D0W-0490Q17D2035L \x05ZZ1047D3414C137/G5W-4100C17D2035L
ZZ1047C3414C145/D0W-0490X17D2035L \x05ZZ1047D3414C145/F0B-4100C17D2035L
ZZ1047C3414C145/F5B-0490J17D2035L \x05ZZ1047D3414C145/F0B-4100N17D2035L
ZZ1047C3414C145/F5B-0490X17D2035L \x05ZZ1047D3414C145/F0W-4100C17D2035L
ZZ1047C3414C145/F5W-0490X17D2035L \x05ZZ1047D3414C145/F0W-4100C19D2442L
ZZ1047C3414C145/F5W-0490X17D2235L \x05ZZ1047D3414C145/F0W-4100N17D2035L
ZZ1047D3413C137/F0B-4100N17D2035L \x05ZZ1047D3414C145/F0W-4100N17D2235L
ZZ1047D3413C145/G5B-4100C17D2035L \x05ZZ1047D3414C145/G0B-4102C19D2442L
ZZ1047D3414C137/F0B-4100N17D2035L \x05ZZ1047D3414C145/G0B-4102N17D2035L
ZZ1047D3414C137/F0B-4100N19D2442L \x05ZZ1047D3414C145/G0B-4102N19D2442L
ZZ1047D3414C137/G5B-4100C17D2235L \x05ZZ1047D3414C145/G0W-4102C19D2442L
ZZ1047D3414C137/G5B-4100C19D2442L \x05ZZ1047D3414C145/G0W-4102N17D2035L
ZZ1047D3414C137/G5W-4100N17D2235L \x05ZZ1047D3414C145/G0W-4102N19D2442L
ZZ1047D3414C137/I5B-4102C19D2442L \x05ZZ1047D3414C145/G5B-4100C17D2035L
ZZ1047D3414C145/F0B-4100C17D2035L \x05ZZ1047D3414C145/G5B-4100C19D2242L
ZZ1047D3414C145/F0B-4100C17D2235L \x05ZZ1047D3414C145/G5B-4100C19D2442L
ZZ1047D3414C145/F0B-4100C19D2242L \x05ZZ1047D3414C145/G5W-4100C17D2035L
这个表比较长,不能全部发上来.手工找却是有10多个重复的.
请解读一下=IF(COUNTIF(B:B,A1)=0,A1,"")OFFICE2003里相比较A列与B列的数值,相同的在C列输出0,不同的在C列输出A列对应的数值,为什么利用上面的函数在C列得到的是全部A列的数值?A列 B列ZZ1047C2813C137/D0B-
我用你的公式和数据做了一下,不像你说的那样,还是哪里出了问题