比较两张excel表 [英] Compare two excel sheets

问题描述

如何比较两个excel表并确定缺少哪一列?

How do I compare two excel sheet and determine which column is missing?

(我想比较工作表 A 和工作表 B 中的国家列表，然后标出缺少哪个国家)

(I would like to compare a list of countries from sheet A with sheet B, then mark which country is missing)

注意:它们的顺序是随机的.

Note: They are in random order.

推荐答案

您可以在 Excel 工作表中使用 VLOOKUP 函数来帮助在不同的工作表中查找缺失"的数据.例如，以下两个工作表:

You can use the VLOOKUP function in an Excel worksheet to help finding "missing" data in a different sheet. For example, take the following two worksheets:

Sheet1
------
       A          B         C
1     aa 
2     bb
3     cc 
4     dd

.

Sheet2
------
       A          B         C
1     aa 
2     bb
3     dd 

将以下公式添加到Sheet中的单元格B1，然后将公式向下拖动到单元格B4:

Add the following formula to cell B1 in Sheet and drag the formula down through cell B4:

=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$A$3,1,FALSE)),"MISSING FROM OTHER SHEET","")

Sheet1 应该指出 B 列中另一张工作表中缺少的项目，如下所示:

Sheet1 should indicate items that are missing from the other sheet in column B, like so:

Sheet1
------
       A          B                        C
1     aa 
2     bb
3     cc         MISSING FROM OTHER SHEET
4     dd

这篇关于比较两张excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！