Comparing unsorted data across separate files
Closed
TechNotAAnalyst
Posts
1
Registration date
Friday August 22, 2014
Status
Member
Last seen
August 22, 2014
-
Aug 22, 2014 at 11:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 23, 2014 at 11:55 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 23, 2014 at 11:55 AM
Related:
- Comparing unsorted data across separate files
- Tmobile data check - Guide
- Clear recent files windows 11 - Guide
- How to open msi files on android - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Recover my files - Download - Backup and recovery
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 23, 2014 at 11:55 AM
Aug 23, 2014 at 11:55 AM
TechNotAAnalyst, Good afternoon.
You did not say how you want the comparison be made.
Column C (location) has some importance in this comparison?
Here is a formula to compare serial numbers.
=IF(ISERROR(MATCH(E2,order!$G$2:$G$11,0),0)>0,"OK","NOT ORDERED")
Adapt as your reality.
Put this f'ormula in column F of the spreadsheet inventory.
Copy IT down.
If you prefer, save your excel file at a free site, www.speedyshare.com and put a link here to download.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You did not say how you want the comparison be made.
Column C (location) has some importance in this comparison?
Here is a formula to compare serial numbers.
=IF(ISERROR(MATCH(E2,order!$G$2:$G$11,0),0)>0,"OK","NOT ORDERED")
Adapt as your reality.
Put this f'ormula in column F of the spreadsheet inventory.
Copy IT down.
If you prefer, save your excel file at a free site, www.speedyshare.com and put a link here to download.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão