OFFICE2003里相比较A列与B列的数值,相同的在C列输出0,不同的在C列输出A列对应的数值,为什么利用上面的函数在C列得到的是全部A列的数值?哪里有问题?
A列 B列
ZZ1047C2813C137/D0B-0490Q17D2035L ZZ1047A3413A1/A0WSX-B
ZZ1047C2813C137/D0B-0490X17D2035L ZZ1047A3414A1/A0WSJ-B
ZZ1047C2813C145/D0B-0490Q17D2035L ZZ1047B2813B1/B0WSQ-B
ZZ1047C2813C145/D0B-0490X17D2035L ZZ1047C3413C145/D0B-0490Q17D2035L
ZZ1047C2813C145/D0W-0490J17D2035L ZZ1047C3413C145/D0B-0490X17D2035L
ZZ1047C2813C145/D0W-0490X17D2035L ZZ1047C3413C145/D0W-0490Q17D2035L
ZZ1047C2814C145/D0B-0490Q17D2035L ZZ1047C3413C145/D0W-0490X17D2035L
ZZ1047C2814C145/D0B-0490X17D2035L ZZ1047C3414B1/C0BSJ-B
ZZ1047C3413C137/F5W-0490X17D2035L ZZ1047C3414B145/C0WUC-B
ZZ1047C3413C145/D0B-0490Q17D2035L ZZ1047C3414C145/D0B-0490Q17D2035L
ZZ1047C3413C145/D0B-0490X17D2035L ZZ1047C3414C145/D0B-0490X17D2035L
ZZ1047C3413C145/D0W-0490Q17D2035L ZZ1047C3414C145/D0W-0490Q17D2035L
ZZ1047C3413C145/D0W-0490X17D2035L ZZ1047C3414C145/D0W-0490Q17D2235L
ZZ1047C3413C145/D0W-0490X17D2235L ZZ1047C3414C145/D0W-0490Q19D2442L
ZZ1047C3413C145/F5B-0490X17D2035L ZZ1047C3414C145/D0W-0490X17D2035L
ZZ1047C3413C145/F5W-0490J17D2035L ZZ1047C3414C145/F5B-0490J17D2035L
ZZ1047C3413C145/F5W-0490X17D2035L ZZ1047C3414C145/F5B-0490X17D2035L
ZZ1047C3414C145/D0B-0490Q17D2035L ZZ1047C3414C145/F5W-0490Q19D2442L
ZZ1047C3414C145/D0B-0490X17D2035L ZZ1047C3414C145/F5W-0490X17D2035L
ZZ1047C3414C145/D0B-0490X17D2235L ZZ1047D3414B1/D0WVN-B
ZZ1047C3414C145/D0W-0490J17D2035L ZZ1047D3414C137/F0B-4100N17D2035L
ZZ1047C3414C145/D0W-0490Q17D2035L ZZ1047D3414C137/G5W-4100C17D2035L
ZZ1047C3414C145/D0W-0490X17D2035L ZZ1047D3414C145/F0B-4100C17D2035L
ZZ1047C3414C145/F5B-0490J17D2035L ZZ1047D3414C145/F0B-4100N17D2035L
ZZ1047C3414C145/F5B-0490X17D2035L ZZ1047D3414C145/F0W-4100C17D2035L
ZZ1047C3414C145/F5W-0490X17D2035L ZZ1047D3414C145/F0W-4100C19D2442L
ZZ1047C3414C145/F5W-0490X17D2235L ZZ1047D3414C145/F0W-4100N17D2035L
ZZ1047D3413C137/F0B-4100N17D2035L ZZ1047D3414C145/F0W-4100N17D2235L
ZZ1047D3413C145/G5B-4100C17D2035L ZZ1047D3414C145/G0B-4102C19D2442L
ZZ1047D3414C137/F0B-4100N17D2035L ZZ1047D3414C145/G0B-4102N17D2035L
ZZ1047D3414C137/F0B-4100N19D2442L ZZ1047D3414C145/G0B-4102N19D2442L
ZZ1047D3414C137/G5B-4100C17D2235L ZZ1047D3414C145/G0W-4102C19D2442L
ZZ1047D3414C137/G5B-4100C19D2442L ZZ1047D3414C145/G0W-4102N17D2035L
ZZ1047D3414C137/G5W-4100N17D2235L ZZ1047D3414C145/G0W-4102N19D2442L
ZZ1047D3414C137/I5B-4102C19D2442L ZZ1047D3414C145/G5B-4100C17D2035L
ZZ1047D3414C145/F0B-4100C17D2035L ZZ1047D3414C145/G5B-4100C19D2242L
ZZ1047D3414C145/F0B-4100C17D2235L ZZ1047D3414C145/G5B-4100C19D2442L
ZZ1047D3414C145/F0B-4100C19D2242L ZZ1047D3414C145/G5W-4100C17D2035L
这个表比较长,不能全部发上来。手工找却是有10多个重复的。
æç¨ä½ çå ¬å¼åæ°æ®åäºä¸ä¸ï¼ä¸åä½ è¯´çé£æ ·ï¼è¿æ¯åªéåºäºé®é¢
追é®æï¼æåå®ç»æCåäºAåå®å ¨ç¸åãOFFICE2003ä¸2007é½è¯äºãåªéåºäºé®é¢ï¼
追çåè¿æ¥å¸®ä½ ççQ55865370
问题是现在C列输出的和A列完全相同。这个表比较长,不能全部发上来。手工找却是有10多个重复的。
这个表比较长,不能全部发上来。手工找却是有10多个重复的。
追答公式本身没有错,你检查一下两点:
1、数据格式是不是一列文本一列数字
2、对比的数据里面是不是含有空格,请选择AB两列,查找空格并且替换为“”