Find the differences between 2 Excel worksheets

0 votes
I have two excel files with the same structure: they both have 1 column with data. One has 800 records and the other has 805 records, but I am not sure which of the 5 in the 805 sets is not in the 800 sets. Can I find this out using Excel?
Nov 13 in Others by Kithuzzz
• 20,660 points
45 views

1 answer to this question.

0 votes

Place your column in column A of each spreadsheet, with one value per row. Type in column B of the bigger sheet.

=VLOOKUP(A1,'[Book2.xlsb]SheetName'!$A:$A,1,FALSE)

Then, duplicate the formula as far as your data column will allow.

If the formula returns FALSE, the corresponding data is not present in the other worksheet.

answered Nov 13 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
32 views
0 votes
1 answer

Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer

What is the difference between hadoop and google analytics ?

I will try and answer this as ...READ MORE

answered Aug 22, 2018 in Others by Frankie
• 9,830 points
879 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
397 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,371 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,836 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
32 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP