如何在Excel中比较2列 [英] How to compare 2 columns in excel

问题描述

我有A列和B列.我想做的是复制C列，并删除匹配/包含B列中的行.

我有这个公式，但是它不会删除仅包含匹配项的行:

  = ARRAYFORMULA(IF(ISNA(MATCH(A:A，B:B，0))，A:A，")) 

对此有任何公式/查询吗?

您可以在此处看到它(请在此处查看评论建议):

解决方案

如果将c列第1行中的公式设置为"= if(a1 = b1,1,0)"，则可以只过滤其中的值列c = 1并删除这些行.这样，当您将c列复制到另一列或将数据复制到任何其他位置时，将不会获得匹配项以进行复制.

I have Column A and Column B. What I want to do is copy Column C and remove rows which match/contain rows in Column B.

I have this formula but it doesn't remove containing rows, only matching:

=ARRAYFORMULA(IF(ISNA(MATCH(A:A,B:B,0)),A:A,""))

Any formula/query for this?

You can see it live here (please comment suggestion there): https://docs.google.com/spreadsheets/d/1EBJgRAt0UfyfP_zgv3RITNnN3VW3KXoeiIC9mDTjJL4/edit?usp=sharing

解决方案

If you set the formula in column c row 1 as "=if(a1 = b1,1,0)", then you could just filter on values in column c = 1 and delete those rows. That way when you copy column c to another column or where ever else you are copying the data, you will not get the matching items to copy over.

这篇关于如何在Excel中比较2列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！