Hi everyone,

I need to reconcile two spreadsheets (each has about 20 columns and 300 rows) that contain the same data but come from two different sources. I need an easy way to spot the differences. The columns (types of loans) are the same on both spreadsheets and the names of my projects in the first column should also match on both.

I already tried conditional formatting using countif but that doesn't show me all the differences. It doesn't highlight those numbers that are the same in value but for different projects and type of loan.

Hope this makes sense. Any help is appreciated.

Thanks

Franzi