Formula to compare 2 excel spreadsheets and find the difference

Closed
Lana - Jul 29, 2016 at 01:21 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 29, 2016 at 02:06 PM
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.



Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 29, 2016 at 02:06 PM
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
0