Excel两列与重复 [英] Excel Two Columns With Duplicates

问题描述

所以我在excel中有两列，列A包含与列B几乎完全相同的数据。

我需要一种方法来将列A与列B匹配，列A和列B中相同的任何值必须从列B中删除。

所以列A有11,592个产品SKU号。

列B有12,555个产品SKU编号。

我需要一种方法来从B列获得SK >

解决方案

在单元格C1中使用以下公式：

  = IF（VLOOKUP（B1，A：A，1）= B1，，B1）
  

复制并粘贴到列B中具有值的所有行，并显示唯一的值。

然后通过粘贴值将列C复制到列D，以便您可以排序/过滤掉空白。

So I have two columns in excel with column A containing nearly the exact same data as column B.

I need a way to Match column A with Column B and any values that are the same in Column A and Column B need to be removed from Column B.

So Column A has 11,592 product SKU numbers.

Column B has 12,555 product SKU numbers.

And I need a way to get the SKU product numbers from Column B that are not in Column A. Maybe put them into Column C?

解决方案

In cell C1 use this formula:

=IF(VLOOKUP(B1,A:A,1)=B1,"",B1)

Copy and paste it to all rows that have a value in column B and it will show the unique values.

Then copy column C to column D by Paste Values so that you can sort it / filter out blanks.

这篇关于Excel两列与重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！