Forum Discussion

Dan1ExcelUser's avatar
Dan1ExcelUser
Copper Contributor
Sep 18, 2025

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)

ABCDEF
BankBank CodeCountryBank BranchBank CodeSWIFT Code
Value 1Value 2Value 3Value 4Value 5Value 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

Resources