Formula to compare 2 excel spreadsheets and find the difference

Closed
Lana - Jul 29, 2016 at 01:21 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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.



1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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