|
通过excel计算:
下面为公式
ID | X | Y | 合并 | 求重 | 1 | 40491680 | 4571177 | =B2&" "&C2 | =COUNTIF($D$22,D2) | 2 | 40491691 | 4571118 | =B3&" "&C3 | | 3 | 40491758 | 4571130 | =B4&" "&C4 | | 4 | 40491773 | 4571085 | =B5&" "&C5 | | 5 | 40491788 | 4571035 | =B6&" "&C6 | | 6 | 40491815 | 4570974 | =B7&" "&C7 | | 7 | 40491841 | 4570916 | =B8&" "&C8 | | 8 | 40491866 | 4570863 | =B9&" "&C9 | | 结果:
ID | X | Y | 合并 | 求重 | 1 | 40491680 | 4571177 | 40491680 4571177 | 1 | 2 | 40491691 | 4571118 | 40491691 4571118 | 1 | 3 | 40491758 | 4571130 | 40491758 4571130 | 1 | 4 | 40491773 | 4571085 | 40491773 4571085 | 1 | 5 | 40491788 | 4571035 | 40491788 4571035 | 1 | 6 | 40491815 | 4570974 | 40491815 4570974 | 1 | 7 | 40491841 | 4570916 | 40491841 4570916 | 1 | 8 | 40491866 | 4570863 | 40491866 4570863 | 1 | 9 | 40491890 | 4570812 | 40491890 4570812 | 1 |
对求重的筛选。不等于的删除掉。
|
|