Forum Discussion
Dan1ExcelUser
Sep 18, 2025Copper Contributor
Which formula to use to compare 2 spreadsheets that have 6 columns?
Hi,
I have 2 spreadsheet, A and B, and both have 6 columns, like the table below, and more than 7k rows (6 x 7k)
A | B | C | D | E | F |
Bank | Bank Code | Country | Bank Branch | Bank Code | SWIFT Code |
Value 1 | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 |
I would like to compare spreadsheet A and B to find which values is missing into B. And, I assume that SheetA!Value1=SheetB!Value1, SheetA!Value2=SheetB!Value2,..,SheetA!Value6=SheetB!Value6
I tried this formula IFERROR(IF(MATCH(1,(A:A=SheetB!A:A)*(B:B=SheetB!B:B)*(C:C=SheetB!C:C)*(D:D=SheetB!C:C)*(E:E=SheetB!E:E)*(F:F=SheetB!F:F),0),"Added"),"Missing").
The problem with this formula it's take a lot time to give a result. My spreadsheets have Excel is very slow and my PC is freezing.
So, I don't know if this formula is good nor if there is another one that won't slow down my PC.
Best regards
No RepliesBe the first to reply