UC知道excel 去除同一框内重复2个数字！
来源：百度知道 编辑：UC知道 时间：2024/09/24 14:10:55
我想去除在同一个表内就是复制过来到A1里面的所有数字只记录一次的方法，谢谢！如下：
72,13,05,31,09,74,47,04,20,91,64,78,57,45,15,73,79,65,37,49,76,60,25,26,71,96,87,52,48,69,34,10,93,14,28,86,68,62,46,02,84,38,42,94,54,80,35,03,51,70,08,08,45,47,40,79,68,73,20,10,54,71,05,91,35,30,18,60,81,87,96,65,52,62,90,80,25,39,37,36,01,64,17,89,49,74,59,86,28,93,70,06,53,07,38,27,68,26,89,72,31,79,58,62,28,86,52,38,75,13,91,98,65,67,23,03,09,17,82,01,87,18,84,15,60,34,97,19,56,37,92,07,30,45,20,06,40,16,35,73,36,42,54,64,70,05,47,29,97,73,49,07,65,98,91,51,03,50,36,56,30,21,46,09,05,67,31,14,72,57,40,79,64,90,18,48,58,04,39,47,76,16,92,45,74,83,68,02,29,54,86,59,28,08,62,38,20,89,49,38,94,63,27,28,91,59,84,70,19,76,09,86,41,67,46,56,15,23,08,57,85,78,07,72,96,35,05,26,36,01,14,48,73,61,25,13,43,60,03,58,93,75,74,37,90,41,98,59,27,81,36,62,30,09,29,75,69,67,47,87,89,35,65,73,19,97,23,57,70,25,31,13,45,54,83,34,07,53,43,79,85,94,71,15,01,28,42，
上面只要是重复的2个号码就自动去除！留下不重复的！
数字都是在A1里面，A2以后都没有！
72,13,05,31,09,74,47,04,20,91,64,78,57,45,15,73,79,65,37,49,76,60,25,26,71,96,87,52,48,69,34,10,93,14,28,86,68,62,46,02,84,38,42,94,54,80,35,03,51,70,08,08,45,47,40,79,68,73,20,10,54,71,05,91,35,30,18,60,81,87,96,65,52,62,90,80,25,39,37,36,01,64,17,89,49,74,59,86,28,93,70,06,53,07,38,27,68,26,89,72,31,79,58,62,28,86,52,38,75,13,91,98,65,67,23,03,09,17,82,01,87,18,84,15,60,34,97,19,56,37,92,07,30,45,20,06,40,16,35,73,36,42,54,64,70,05,47,29,97,73,49,07,65,98,91,51,03,50,36,56,30,21,46,09,05,67,31,14,72,57,40,79,64,90,18,48,58,04,39,47,76,16,92,45,74,83,68,02,29,54,86,59,28,08,62,38,20,89,49,38,94,63,27,28,91,59,84,70,19,76,09,86,41,67,46,56,15,23,08,57,85,78,07,72,96,35,05,26,36,01,14,48,73,61,25,13,43,60,03,58,93,75,74,37,90,41,98,59,27,81,36,62,30,09,29,75,69,67,47,87,89,35,65,73,19,97,23,57,70,25,31,13,45,54,83,34,07,53,43,79,85,94,71,15,01,28,42，
上面只要是重复的2个号码就自动去除！留下不重复的！
数字都是在A1里面，A2以后都没有！
在B1输入公式：
=MID(A$1,(ROW()-1)*3+1,2)
将公式向下复制。
用选择性粘贴将B列公式值固定下来。
用高级筛选/选择不重复的记录。
哎，都是前后二码惹的祸！
这个基本上要用宏才能解决了！
算法应当算有小小复杂：读数据、排序、去重复，有空我可以写个玩下。
有一办法，就是先用“逗号”来分列，然后再用高级筛选选择不重复即可。