Comparing Spreadsheets

Closed
Report
Posts
1
Registration date
Thursday October 8, 2015
Status
Member
Last seen
October 8, 2015
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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