Comparing Spreadsheets

Closed
melbaboone Posts 1 Registration date Thursday October 8, 2015 Status Member Last seen October 8, 2015 - Oct 8, 2015 at 03:38 PM
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 - Oct 8, 2015 at 05:14 PM
I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare spreadsheet 1 against spreadsheet 2 to make sure I have the same names spreadsheet 1 has 417 names spreadsheet 2 has 427 names. Can someone direct me please. Thank you so much
Mel

1 reply

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Oct 8, 2015 at 05:14 PM
melbaboone, Good evening.

There are a lot of ways to do this.

My suggestion:
Suppose:

Sheet1
A1:A500 - Names

Sheet2
C1:C1000 - Names

Try to use:

Sheet1
B1 -->
=IF(ISERROR(MATCH(A1;Plan2!C1:C1000,0)),"NOT FOUND","----OK----")

Sheet2
D1 -->
=IF(ISERROR(MATCH(C1;Plan1!A1:A500,0)),"NOT FOUND","----OK----")


Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0