[再次编辑] 我也来求一个Excel问题,我办公室内高手都没法解决

skeny-avatar

skeny

2020-08-29T01:56:58+00:00

有AB两列,存在内容相同但是顺序相反的数据,如:AB,BA

[img]https://img.nga.178.com/attachments/mon_202009/04/-7Q5-3l9oK1gT3cSlc-sg.jpg.medium.jpg[/img]


现在想删除所有BA类型的数据,要怎么做呢?先谢过各位大神了


[img]https://img.nga.178.com/attachments/mon_202009/04/-7Q5-d020Z27T3cSp0-xc.jpg.medium.jpg[/img]

需要删除标黄这类数据
[img]https://img.nga.178.com/attachments/mon_202009/04/-7Q5-dcxbZkT3cSlc-sg.jpg.medium.jpg[/img]


语文老师要被我气死了[s:ac:瞎]