Forum Discussion
Gluksker
Oct 19, 2021Copper Contributor
Comparing two large excel sheets
I have two large excel files. I have to to combine the two files to see who is missing from the first file to the second file. The files are mostly the same besides a handful of differences. I can...
Gluksker
Oct 19, 2021Copper Contributor
So they all do have ID numbers. It’s an Active roster sheet. So I get the first sheet and shows me all active, when I get the next sheet, shows me all active again but will now have people missing that have been terminated. So I need to compare the two to find who has disappeared from the original sheet compared to the second sheet
Deleted
Oct 19, 2021Gluksker Hey again,
in that case you can use a lookup function, e.g.:
ID - Sheet 1 | Check | ID - Sheet 2 |
1 | =XLOOKUP(A2;C:C;C:C;"Missing") | 2 |
2 | 2 | 3 |
3 | 3 | 5 |
4 | 4 | 4 |
5 | 5 | 6 |
6 | 6 | 7 |
7 | 7 | |
8 | Missing | |
9 | Missing | |
10 | Missing |
But depending on your machine, this can take some time, or could lead the file to crash.