I have two columns in a spreedsheet each with different values, I need to compare the two columns and remove the duplicates from each. I need the columns to stay separate from each other so I cant remove the duplicates and mash the two columns into one. How do I remove the duplicates while keeping the columns separate?
我在spreedsheet中有两列,每列都有不同的值,我需要比较两列,并从每个列中删除重复项。我需要列彼此分开,所以我不能删除重复项并将两列混合成一列。如何在保持列分离的同时删除重复项?
1 个解决方案
#1
0
The simplest way for you to do this would be to have one column next to each of your data columns where you can have the formulas.
您执行此操作的最简单方法是在每个数据列旁边都有一列,您可以在其中拥有公式。
Say that you have the data in column A and D.
假设您有A列和D列中的数据。
In column B you can write;
在B栏中你可以写;
=IF(IFERROR(MATCH(A1;D:D;0);FALSE);A1;"")
And copy this to all rows below. In column E you can write;
并将其复制到下面的所有行。在E栏中你可以写;
=IF(IFERROR(MATCH(D1;A:A;0);FALSE);D1;"")
And copy to all rows in E.
并复制到E中的所有行。
This will write out the value if it exists in the other column.
如果该值存在于另一列中,则会写出该值。
#1
0
The simplest way for you to do this would be to have one column next to each of your data columns where you can have the formulas.
您执行此操作的最简单方法是在每个数据列旁边都有一列,您可以在其中拥有公式。
Say that you have the data in column A and D.
假设您有A列和D列中的数据。
In column B you can write;
在B栏中你可以写;
=IF(IFERROR(MATCH(A1;D:D;0);FALSE);A1;"")
And copy this to all rows below. In column E you can write;
并将其复制到下面的所有行。在E栏中你可以写;
=IF(IFERROR(MATCH(D1;A:A;0);FALSE);D1;"")
And copy to all rows in E.
并复制到E中的所有行。
This will write out the value if it exists in the other column.
如果该值存在于另一列中,则会写出该值。