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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 05:14 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 05:14 PM
Related:
- Comparing Spreadsheets
- Compare excel spreadsheets - Guide
- How to use spreadsheets - Guide
- Find missing data between two spreadsheets - Excel Forum
- Comparing data between two excel sheets ✓ - Excel Forum
- Comparing two columns of names in Excel ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 8, 2015 at 05:14 PM
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
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
