Hi,
I'm not sure if this is the right sub-forum, but I have a problem. I have two different Excel files and I'm wondering if it is possible to find matching words or numbers in both Excel files.
For example
File 1:
ru*****re ruz***[email protected] 16-12-2016 21:24:02+00:00 45725 EU 71791 A***e Ru****a CA PAID_Betaalbewijs True
afri****tia1 t****[email protected] 12-12-2016 07:32:38+00:00 45806 EU 71097 Le**ia Pie***olas PF PAID_Betaalbewijs True
File 2:
20170101 J***a St****n 246 Name: J***a St****n Omschrijving: Bla bla bla 45725 IBAN: DE11**************8
20170101 A**a C***na 296 Name: A**a C***na Omschrijving: Bla bla bla 45806 IBAN: PL**********271
The bold numbers are matching. How can I build a program that does this automatically because I have about 40K rows in Excel.
Bookmarks