formula to compare 2 excel spreadsheets and find the difference Closed

Question

Hello, 
Would you be able to help me to find the formula to compare two excel spreadsheets?
I want to see if items appears on both spreadsheets.  For instance, I  want to see the  value in columns A, B, C  are the same as the   value in columns A, B, C. If not, show me as "Not Match" and highlight the column.
I really appreciate your help.
Regards, Lana.



Configuration: Windows 7 / Firefox 47.0

Mazzaropi · Answer

Lana, Good afternoon.

I'm not sure if I understood well your question.

I did a little example for you:
http://speedy.sh/8TCVT/A.xlsx
http://speedy.sh/qsYds/B.xlsx 

Please, tell us if it worked for yoiu.
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Formula to compare 2 excel spreadsheets and find the difference

1 response

Similar discussions

Subscribe To Our Newsletter!