Fuzzy Match code

G

gelu

Board Regular
Joined
Sep 30, 2022
Messages
85
Office Version
  1. 2021
Platform
  1. Windows
Hello everyone,

I seek help for a macro or UDF (Excel 2010-2019):
- able to do fuzzy matches
- allowing to select the similarity threshold

I have lists of prospective clients.
Each of them (every new prospect) has to be looked up against a long list of SDN (specially designed nationals) - could be simply names but often entire sentences within a cell.

Using the Fuzzy add-in does the job (it crashes now and then, though)
but not every user can handle it (unless trained beforehand, which is not always possible).

The Fuzzy UDF posted here:

... is simply amazing if the lookup table is short (like 100 rows):

But, when the SDN table holds +230,000 rows the Fuzzy UDF
- just makes Excel go nuts/stop responding (the Fuzzy add-in is rather slow, too, but it does so quietly, no blank screens)
- if it does come back ... it does not figure out all of the samples I use to check it out.

If I use a SDN table with ~ 400 rows the Fuzzy UDF does not figure out any of the samples

Any assistance would be appreciated.

Thank you in advance!

Gelu

template 0051.xlsm
ABCD
15%
2I tried these as 4rth argument =>50%
399%
4
5Column1SamplesFuzzy UDF
6Saddam Hussein Al-TikritiSaddam Hussein Al-TikritiSaddam Hussein Al-Tikriti
7Abu AliAbu AliAbu Ali
8Abou AliЧерен септемвриЧерен септември
9Επαναστατική Οργάνωση Σοσιαλιστών Μουσουλμάνωνثناء اللہ غفاریثناء اللہ غفاری
10Μαύρος Σεπτέμβρηςa.k.a. WELFARE OF HUMANITY; a.k.a. "JUD"; a.k.a. "MML"; a.k.a.a.k.a. WELFARE OF HUMANITY; a.k.a. "JUD"; a.k.a. "MML"; a.k.a.
11Αραβικές Επαναστατικές Ταξιαρχίεςa.k.a. AL-ASHQAR, 'Abdallah; a.k.a. AL-ASHQAR, Abdallah; a.k.a. AL-a.k.a. AL-ASHQAR, 'Abdallah; a.k.a. AL-ASHQAR, Abdallah; a.k.a. AL-
12Επαναστατικό Συμβούλιο ΦατάχGénéral Ali DarassaGénéral Ali Darassa
13Οργάνωση Abu Nidal
14Революционна организация на мюсюлманите социалисти
15Черен септемвриhttps://www.mrexcel.com/board/forums/excel-questions.10/post-thread
16Арабски революционни бригади
17Instituto Nicaragüense de Telecomunicaciones y Correos
18Никарагуански институт по телекомуникации и пощенски услуги
19Institut nicaraguayen des télécommunications et des services postaux
20Ινστιτούτο Τηλεπικοινωνιών και Ταχυδρομείων της Νικαράγουας
21ثناء اللہ غفاری
22Général Ali Darassa
23TEHREEK-E-AZADI-E-KASHMIR; a.k.a. TEHREEK-I-AZADI-I KASHMIR; a.k.a.
24TEHRIK-E-HURMAT-E-RASOOL; a.k.a. TEHRIK-E-TAHAFUZ QIBLA AWWAL;
25a.k.a. WELFARE OF HUMANITY; a.k.a. "JUD"; a.k.a. "MML"; a.k.a.
26"TAJK"), Pakistan [FTO] [SDGT].
27AL MAQDISI, Abu al Muhtasib (a.k.a. AL ASHQAR, Abdullah Jihad;
28a.k.a. AL-ASHQAR, 'Abdallah; a.k.a. AL-ASHQAR, Abdallah; a.k.a. AL-
29'ASHQAR, 'Abdallah; a.k.a. AL-ASHQAR, 'Abdallah Jihad Musa; a.k.a.
30AL-ASHQAR, Abdullah; a.k.a. AL-ASHQAR, Abdullah Jihad; a.k.a. AL-
31MAQDISI, Abu-al-Muhtasib; a.k.a. AL-TAWHID, Muhandes; a.k.a. AL-
32TAWHID, Muhandis; a.k.a. ASHKAR, Abdallah; a.k.a. "ABU-HAJIR";
33a.k.a. "AL MUHTASIB, Abu"), Region: Gaza; DOB 1986; nationality
34Palestinian (individual) [SDGT].
35AL MARRANI, Mutlaq Ali Aamer (a.k.a. AL-MARRANI, Motlaq Amer;
36a.k.a. "EMAD, Abu"), Al-Jawf, Yemen; DOB 01 Jan 1984; Gender Male
37(individual) [GLOMAG].
38AL MASHREK FUND (a.k.a. AL MASHREK HOLDING; a.k.a. AL MASHREQ
39INVESTMENT FUND; a.k.a. AL MASHRIQ HOLDING; a.k.a. AL MASHRIQ
40INVESTMENT FUND; a.k.a. "MASHRIQ"), Damascus, Syria [SYRIA].
41AL MASHREK HOLDING (a.k.a. AL MASHREK FUND; a.k.a. AL MASHREQ
42INVESTMENT FUND; a.k.a. AL MASHRIQ HOLDING; a.k.a. AL MASHRIQ
43INVESTMENT FUND; a.k.a. "MASHRIQ"), Damascus, Syria [SYRIA].
44AL MASHREQ INVESTMENT FUND (a.k.a. AL MASHREK FUND; a.k.a. AL
45MASHREK HOLDING; a.k.a. AL MASHRIQ HOLDING; a.k.a. AL MASHRIQ
46INVESTMENT FUND; a.k.a. "MASHRIQ"), Damascus, Syria [SYRIA].
47AL MASHRIQ HOLDING (a.k.a. AL MASHREK FUND; a.k.a. AL MASHREK
48HOLDING; a.k.a. AL MASHREQ INVESTMENT FUND; a.k.a. AL MASHRIQ
49INVESTMENT FUND; a.k.a. "MASHRIQ"), Damascus, Syria [SYRIA].
50AL MASHRIQ INVESTMENT FUND (a.k.a. AL MASHREK FUND; a.k.a. AL
51MASHREK HOLDING; a.k.a. AL MASHREQ INVESTMENT FUND; a.k.a. AL
52MASHRIQ HOLDING; a.k.a. "MASHRIQ"), Damascus, Syria [SYRIA].
53AL MASRAF AL ZERAEI AL TAWENI (a.k.a. AGRICULTURAL COOPERATIVE
54AL MASRI, Abd Al Wakil (a.k.a. ALI, Hassan; a.k.a. AL-NUBI, Abu;
55a.k.a. ELBISHY, Moustafa Ali; a.k.a. FADHIL, Mustafa Mohamed;
56a.k.a. FADIL, Mustafa Muhamad; a.k.a. FAZUL, Mustafa; a.k.a. JIHAD,
57Abu; a.k.a. MAN, Nu; a.k.a. MOHAMMED, Mustafa; a.k.a. "ANIS, Abu";
58a.k.a. "HUSSEIN"; a.k.a. "KHALID"; a.k.a. "YUSSRR, Abu"); DOB 23
59changes to the SDN List.
602ND ACADEMY OF NATURAL SCIENCES (a.k.a. ACADEMY OF NATURAL
61SCIENCES; a.k.a. CHAYON KWAHAK-WON; a.k.a. CHE 2 CHAYON KWAHAK-WON;
62a.k.a. KUKPANG KWAHAK-WON; a.k.a. NATIONAL DEFENSE ACADEMY; a.k.a.
63SANSRI; a.k.a. SECOND ACADEMY OF NATURAL SCIENCES; a.k.a. SECOND
64ACADEMY OF NATURAL SCIENCES RESEARCH INSTITUTE), Pyongyang, Korea,
65North; Secondary sanctions risk: North Korea Sanctions Regulations,
66sections 510.201 and 510.210; Transactions Prohibited For Persons
67Owned or Controlled By U.S. Financial Institutions: North Korea
68Sanctions Regulations section 510.214 [NPWMD].
693G LOJISTIK VE HAVACILIK HIZMETLARI LTD., No. 3/182 Altintepe
70Bagdat Cad. Istasyon Yolu Sok., Istanbul 34840, Turkey; Additional
71Sanctions Information - Subject to Secondary Sanctions [SDGT]
72[IFSR] (Linked To: MAHAN AIR).
737 KARNES, Avenida Ciudad de Cali No. 15A-91, Local A06-07, Bogota,
74Colombia; Matricula Mercantil No 1978075 (Colombia) [SDNTK].
757 MAKARA PHARY CO., LTD., Deaum Mien, Daeum Mien, Ta Khmau, Kandal
768252, Cambodia; Company Number 00037307 (Cambodia) [GLOMAG] (Linked
77To: SOPHARY, Kim).
787TH OF TIR (a.k.a. 7TH OF TIR COMPLEX; a.k.a. 7TH OF TIR INDUSTRIAL
79COMPLEX; a.k.a. 7TH OF TIR INDUSTRIES; a.k.a. 7TH OF TIR INDUSTRIES
80OF ISFAHAN/ESFAHAN; a.k.a. MOJTAMAE SANATE HAFTOME TIR; a.k.a.
81SANAYE HAFTOME TIR; a.k.a. SEVENTH OF TIR), Mobarakeh Road Km 45,
82Isfahan, Iran; P.O. Box 81465-478, Isfahan, Iran; Additional
83Sanctions Information - Subject to Secondary Sanctions [NPWMD]
84[IFSR].
857TH OF TIR COMPLEX (a.k.a. 7TH OF TIR; a.k.a. 7TH OF TIR INDUSTRIAL
86COMPLEX; a.k.a. 7TH OF TIR INDUSTRIES; a.k.a. 7TH OF TIR INDUSTRIES
87OF ISFAHAN/ESFAHAN; a.k.a. MOJTAMAE SANATE HAFTOME TIR; a.k.a.
88SANAYE HAFTOME TIR; a.k.a. SEVENTH OF TIR), Mobarakeh Road Km 45,
89Isfahan, Iran; P.O. Box 81465-478, Isfahan, Iran; Additional
90Sanctions Information - Subject to Secondary Sanctions [NPWMD]
91[IFSR].
927TH OF TIR INDUSTRIAL COMPLEX (a.k.a. 7TH OF TIR; a.k.a. 7TH OF TIR
93COMPLEX; a.k.a. 7TH OF TIR INDUSTRIES; a.k.a. 7TH OF TIR INDUSTRIES
94OF ISFAHAN/ESFAHAN; a.k.a. MOJTAMAE SANATE HAFTOME TIR; a.k.a.
95SANAYE HAFTOME TIR; a.k.a. SEVENTH OF TIR), Mobarakeh Road Km 45,
96Isfahan, Iran; P.O. Box 81465-478, Isfahan, Iran; Additional
97Sanctions Information - Subject to Secondary Sanctions [NPWMD]
98[IFSR].
997TH OF TIR INDUSTRIES (a.k.a. 7TH OF TIR; a.k.a. 7TH OF TIR
100COMPLEX; a.k.a. 7TH OF TIR INDUSTRIAL COMPLEX; a.k.a. 7TH OF TIR
101INDUSTRIES OF ISFAHAN/ESFAHAN; a.k.a. MOJTAMAE SANATE HAFTOME TIR;
102a.k.a. SANAYE HAFTOME TIR; a.k.a. SEVENTH OF TIR), Mobarakeh Road
103Km 45, Isfahan, Iran; P.O. Box 81465-478, Isfahan, Iran; Additional
104Sanctions Information - Subject to Secondary Sanctions [NPWMD]
105[IFSR].
1067TH OF TIR INDUSTRIES OF ISFAHAN/ESFAHAN (a.k.a. 7TH OF TIR; a.k.a.
1077TH OF TIR COMPLEX; a.k.a. 7TH OF TIR INDUSTRIAL COMPLEX; a.k.a.
1087TH OF TIR INDUSTRIES; a.k.a. MOJTAMAE SANATE HAFTOME TIR; a.k.a.
109SANAYE HAFTOME TIR; a.k.a. SEVENTH OF TIR), Mobarakeh Road Km 45,
110Isfahan, Iran; P.O. Box 81465-478, Isfahan, Iran; Additional
111Sanctions Information - Subject to Secondary Sanctions [NPWMD]
112[IFSR].
1137TH SENSE CREATION (a.k.a. SEVENTH SENSE COMPANY LIMITED), Thu Khi
114Tar Street, No.3 Bauk Htaw (15) Quarter, Yankin Township, Yangon,
115Burma; Registration Number 119554144 (Burma) issued 03 Apr 2017
116[BURMA-EO14014].
1178TH IMAM INDUSTRIES GROUP (a.k.a. CRUISE MISSILE INDUSTRY GROUP;
118a.k.a. CRUISE SYSTEMS INDUSTRY GROUP; a.k.a. NAVAL DEFENCE MISSILE
119INDUSTRY GROUP; a.k.a. SAMEN AL-A'EMMEH INDUSTRIES GROUP), Tehran,
120Iran; Additional Sanctions Information - Subject to Secondary
121Sanctions [NPWMD] [IFSR].
12210 SHIPYARD (a.k.a. AO 10 SRZ; a.k.a. JOINT STOCK COMPANY 10 ORDENA
123TRUDOVOGO KRASNOGO ZNAMENI DOCKYARD; a.k.a. JOINT STOCK COMPANY
12410TH AWARDS OF THE LABOR RED BANNER A SHIP REPAIR FACTORY; a.k.a.
125JOINT-STOCK COMPANY 10 SRZ; a.k.a. JSC 10 ORDENA TRUDOVOGO KRASNOGO
126ZNAMENI SUDOREMONTNY FACTORY; a.k.a. JSC 10 ORDENA TRUDOVOGO
127KRASNOGO ZNAMENI SUDOREMONTNY ZAVOD), 19, Lunina Str., Korp.1,
128Bld.2, Polyarny, Murmansk Region 184650, Russia; Organization
129Established Date 03 Jun 2010; Tax ID No. 5116001041 (Russia)
130[RUSSIA-EO14024] (Linked To: JOINT STOCK COMPANY UNITED
131SHIPBUILDING CORPORATION).
13214 STAR SHIPPING MANAGEMENT (a.k.a. FOURTEEN STAR SHIPPING
133MANAGEMENT; a.k.a. "FOURTEEN STARS"), United Arab Emirates;
134Additional Sanctions Information - Subject to Secondary Sanctions
135[SDGT] (Linked To: MEHDI GROUP).
13624X7 PANOPTES (a.k.a. LLC 24X7 PANOPTES; a.k.a. OOO 24X7 PANOPTES),
137Platonova st. 20B-2, Minsk 220005, Belarus; Registration Number
138192603494 (Belarus) [BELARUS-EO14038].
13927TH SCIENTIFIC CENTER (a.k.a. FEDERAL STATE BUDGETARY
140ESTABLISHMENT 27 SCIENTIFIC CENTER OF THE MINISTRY OF DEFENSE OF
141THE RUSSIAN FEDERATION; a.k.a. "27TH NTS"), Brigadirskiy Pereulok
14213, Moscow 105005, Russia [NPWMD] [RUSSIA-EO14024].
14332 COUNTY SOVEREIGNTY COMMITTEE (a.k.a. 32 COUNTY SOVEREIGNTY
144MOVEMENT; a.k.a. IRISH REPUBLICAN PRISONERS WELFARE ASSOCIATION;
145a.k.a. REAL IRA; a.k.a. REAL IRISH REPUBLICAN ARMY; a.k.a. REAL
146OGLAIGH NA HEIREANN; a.k.a. RIRA) [FTO] [SDGT].
14732 COUNTY SOVEREIGNTY MOVEMENT (a.k.a. 32 COUNTY SOVEREIGNTY
148COMMITTEE; a.k.a. IRISH REPUBLICAN PRISONERS WELFARE ASSOCIATION;
149a.k.a. REAL IRA; a.k.a. REAL IRISH REPUBLICAN ARMY; a.k.a. REAL
150OGLAIGH NA HEIREANN; a.k.a. RIRA) [FTO] [SDGT].
15133RD LIGHT INFANTRY DIVISION OF THE BURMESE ARMY, Sagaing, Burma
152[GLOMAG] [BURMA-EO14014].
15333RD SCIENTIFIC RESEARCH AND TESTING INSTITUTE (a.k.a. FEDERAL
154STATE BUDGETARY ESTABLISHMENT 33 CENTRAL SCIENTIFIC RESEARCH TEST
155INSTITUTE OF THE MINISTRY OF DEFENSE OF THE RUSSIAN FEDERATION;
156a.k.a. "33RD TSNIII"), 1 Ulitsa Krasnoznamennaya, Volsk-
15718/Shikhany, Saratov Oblast, Russia; Krasnoznamennaya Street 1,
158Volsk-18, Saratov 412918, Russia [NPWMD] [RUSSIA-EO14024].
15964TH GUARDS DETACHED MOTOR RIFLE BRIGADE (a.k.a. 64TH SEPARATE
160GUARDS MOTORIZED RIFLE BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED
161INFANTRY BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED RIFLE BRIGADE),
162Knyaze-Volkonskoye, Khabarovsk Oblast, Russia; Organization
163Established Date 01 Jan 2009; Target Type Government Entity
164[RUSSIA-EO14024].
16564TH SEPARATE GUARDS MOTORIZED RIFLE BRIGADE (a.k.a. 64TH GUARDS
166DETACHED MOTOR RIFLE BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED
167INFANTRY BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED RIFLE BRIGADE),
168Knyaze-Volkonskoye, Khabarovsk Oblast, Russia; Organization
169Established Date 01 Jan 2009; Target Type Government Entity
170[RUSSIA-EO14024].
17164TH SEPARATE MOTORIZED INFANTRY BRIGADE (a.k.a. 64TH GUARDS
172DETACHED MOTOR RIFLE BRIGADE; a.k.a. 64TH SEPARATE GUARDS MOTORIZED
173RIFLE BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED RIFLE BRIGADE),
174Knyaze-Volkonskoye, Khabarovsk Oblast, Russia; Organization
175Established Date 01 Jan 2009; Target Type Government Entity
176[RUSSIA-EO14024].
17764TH SEPARATE MOTORIZED RIFLE BRIGADE (a.k.a. 64TH GUARDS DETACHED
178MOTOR RIFLE BRIGADE; a.k.a. 64TH SEPARATE GUARDS MOTORIZED RIFLE
179BRIGADE; a.k.a. 64TH SEPARATE MOTORIZED INFANTRY BRIGADE), Knyaze-
180Volkonskoye, Khabarovsk Oblast, Russia; Organization Established
181Date 01 Jan 2009; Target Type Government Entity [RUSSIA-EO14024].
18266TH LIGHT INFANTRY DIVISION (a.k.a. LIGHT INFANTRY DIVISION 66;
183a.k.a. "66 LID"; a.k.a. "#66 DIVISION"; a.k.a. "DIV. 66"; a.k.a.
184"LID 66"), Pyay Township, Bago Region, Burma; Target Type
185Government Entity [BURMA-EO14014].
18676TH GUARDS AIRBORNE ASSAULT CHERNIGOV RED BANNER ORDER OF SUVOROV
187DIVISION (a.k.a. 76TH GUARDS AIRBORNE ASSAULT DIVISION), Pskov,
188Russia; Organization Established Date 01 Sep 1939; Target Type
189Government Entity [RUSSIA-EO14024].
19076TH GUARDS AIRBORNE ASSAULT DIVISION (a.k.a. 76TH GUARDS AIRBORNE
191ASSAULT CHERNIGOV RED BANNER ORDER OF SUVOROV DIVISION), Pskov,
192Russia; Organization Established Date 01 Sep 1939; Target Type
193Government Entity [RUSSIA-EO14024].
19477TH LIGHT INFANTRY DIVISION OF THE BURMESE ARMY, Pegu, Burma
195[BURMA-EO14014].
19682 ELM REALTY LLC, 450 Park Avenue, Ste 1403, New York, NY 10022,
197United States; Company Number 3848561 (New York) (United States)
198[VENEZUELA-EO13850].
19999TH LIGHT INFANTRY DIVISION OF THE BURMESE ARMY, Meiktila, Burma
200[GLOMAG].
201101 DAYS CAMPAIGN (a.k.a. CHARITY COALITION; a.k.a. COALITION OF
202GOOD; a.k.a. ETELAF AL-KHAIR; a.k.a. ETILAFU EL-KHAIR; a.k.a.
203I'TILAF AL-KHAIR; a.k.a. I'TILAF AL-KHAYR; a.k.a. UNION OF GOOD),
204P.O. Box 136301, Jeddah 21313, Saudi Arabia [SDGT].
205126 ECONOMIC EXCHANGE COMPANY (a.k.a. DAEJIN TRADING GENERAL
206CORPORATION; a.k.a. KOREA DAIZIN TRADING CORP.; a.k.a. KOREA DAIZIN
207TRADING CORPORATION; a.k.a. KOREA TAEJIN TRADING; a.k.a. KOREA
208TAEJIN TRADING CORPORATION; a.k.a. KOREA TAIJIN TRADE CORPORATION;
209a.k.a. TAECHIN TRADING CORPORATION; a.k.a. TAEJIN TRADING COMPANY;
210a.k.a. TAEJIN TRADING CORPORATION; a.k.a. TAEJIN TRADING GENERAL
211COMPANY), Hu'ngbu-dong, Moranbong District, Pyongyang, Korea,
212North; Hanoi, Vietnam; Secondary sanctions risk: North Korea
213Sanctions Regulations, sections 510.201 and 510.210; Transactions
214Prohibited For Persons Owned or Controlled By U.S. Financial
215Institutions: North Korea Sanctions Regulations section 510.214;
216Organization Type: Mining of hard coal [DPRK2] [DPRK3].
217140 REMONTNY ZAVOD OAO (a.k.a. 140 REMONTNYI ZAVOD OAO; a.k.a. 140
218REPAIR PLANT JOINT STOCK COMPANY; a.k.a. 140 REPAIR PLANT OPEN
219JOINT STOCK COMPANY; a.k.a. 140TH REPAIR PLANT JSC; a.k.a. JOINT
220STOCK COMPANY 140 REPAIR PLANT; a.k.a. JSC 140 REPAIR PLANT; a.k.a.
221OJSC 140 REPAIR PLANT), 19, Chalovskaya St., Borisov, Minsk Region
222222512, Belarus; 19, L. Chalovskoi Str., Borisov 222512, Belarus;
223Organization Established Date 23 Dec 2009; Target Type State-Owned
224Enterprise; Government Gazette Number 14512525 (Belarus);
225Registration Number 600136102 (Belarus) [BELARUS-EO14038].
226140 REMONTNYI ZAVOD OAO (a.k.a. 140 REMONTNY ZAVOD OAO; a.k.a. 140
227REPAIR PLANT JOINT STOCK COMPANY; a.k.a. 140 REPAIR PLANT OPEN
228JOINT STOCK COMPANY; a.k.a. 140TH REPAIR PLANT JSC; a.k.a. JOINT
229STOCK COMPANY 140 REPAIR PLANT; a.k.a. JSC 140 REPAIR PLANT; a.k.a.
230OJSC 140 REPAIR PLANT), 19, Chalovskaya St., Borisov, Minsk Region
231222512, Belarus; 19, L. Chalovskoi Str., Borisov 222512, Belarus;
232Organization Established Date 23 Dec 2009; Target Type State-Owned
233Enterprise; Government Gazette Number 14512525 (Belarus);
234Registration Number 600136102 (Belarus) [BELARUS-EO14038].
235140 REPAIR PLANT JOINT STOCK COMPANY (a.k.a. 140 REMONTNY ZAVOD
236OAO; a.k.a. 140 REMONTNYI ZAVOD OAO; a.k.a. 140 REPAIR PLANT OPEN
237JOINT STOCK COMPANY; a.k.a. 140TH REPAIR PLANT JSC; a.k.a. JOINT
238STOCK COMPANY 140 REPAIR PLANT; a.k.a. JSC 140 REPAIR PLANT; a.k.a.
239OJSC 140 REPAIR PLANT), 19, Chalovskaya St., Borisov, Minsk Region
240222512, Belarus; 19, L. Chalovskoi Str., Borisov 222512, Belarus;
241Organization Established Date 23 Dec 2009; Target Type State-Owned
242Enterprise; Government Gazette Number 14512525 (Belarus);
243Registration Number 600136102 (Belarus) [BELARUS-EO14038].
244140 REPAIR PLANT OPEN JOINT STOCK COMPANY (a.k.a. 140 REMONTNY
245ZAVOD OAO; a.k.a. 140 REMONTNYI ZAVOD OAO; a.k.a. 140 REPAIR PLANT
246JOINT STOCK COMPANY; a.k.a. 140TH REPAIR PLANT JSC; a.k.a. JOINT
247STOCK COMPANY 140 REPAIR PLANT; a.k.a. JSC 140 REPAIR PLANT; a.k.a.
248OJSC 140 REPAIR PLANT), 19, Chalovskaya St., Borisov, Minsk Region
249222512, Belarus; 19, L. Chalovskoi Str., Borisov 222512, Belarus;
250Organization Established Date 23 Dec 2009; Target Type State-Owned
251Enterprise; Government Gazette Number 14512525 (Belarus);
252Registration Number 600136102 (Belarus) [BELARUS-EO14038].
253140TH REPAIR PLANT JSC (a.k.a. 140 REMONTNY ZAVOD OAO; a.k.a. 140
254REMONTNYI ZAVOD OAO; a.k.a. 140 REPAIR PLANT JOINT STOCK COMPANY;
255a.k.a. 140 REPAIR PLANT OPEN JOINT STOCK COMPANY; a.k.a. JOINT
256STOCK COMPANY 140 REPAIR PLANT; a.k.a. JSC 140 REPAIR PLANT; a.k.a.
257OJSC 140 REPAIR PLANT), 19, Chalovskaya St., Borisov, Minsk Region
258222512, Belarus; 19, L. Chalovskoi Str., Borisov 222512, Belarus;
259Organization Established Date 23 Dec 2009; Target Type State-Owned
260Enterprise; Government Gazette Number 14512525 (Belarus);
261Registration Number 600136102 (Belarus) [BELARUS-EO14038].
262200G PSA HOLDINGS LLC, 80 SW 8th Street Suite 2000, Miami, FL
26333130, United States; Tax ID No. 80-0890696 (United States)
264[SDNTK].
265234TH GUARDS AIR ASSAULT REGIMENT (a.k.a. 234TH GUARDS AIRBORNE
266ASSAULT REGIMENT; a.k.a. 234TH GUARDS BLACK SEA ORDER OF KUTUZOV
267NAMED AFTER ALEXANDER NEVSKY AIR ASSAULT REGIMENT; a.k.a. MILITARY
268UNIT 74268), Pskov, Russia; Target Type Government Entity [RUSSIA-
269EO14024].
270234TH GUARDS AIRBORNE ASSAULT REGIMENT (a.k.a. 234TH GUARDS AIR
271ASSAULT REGIMENT; a.k.a. 234TH GUARDS BLACK SEA ORDER OF KUTUZOV
272NAMED AFTER ALEXANDER NEVSKY AIR ASSAULT REGIMENT; a.k.a. MILITARY
273UNIT 74268), Pskov, Russia; Target Type Government Entity [RUSSIA-
274EO14024].
275234TH GUARDS BLACK SEA ORDER OF KUTUZOV NAMED AFTER ALEXANDER
276NEVSKY AIR ASSAULT REGIMENT (a.k.a. 234TH GUARDS AIR ASSAULT
277REGIMENT; a.k.a. 234TH GUARDS AIRBORNE ASSAULT REGIMENT; a.k.a.
278MILITARY UNIT 74268), Pskov, Russia; Target Type Government Entity
279[RUSSIA-EO14024].
280929 GLITS (a.k.a. 929 STATE FLIGHT TEST CENTER; a.k.a. STATE FLIGHT
281TESTING CENTER NAMED AFTER V.P. CHKALOV), Akhtubinsk, Astrakhan
282Region, Russia; Khmeimim Air Base, Syria; Chkalovsky Airfield,
283Russia; Organization Established Date Oct 1920; Target Type
284Government Entity [RUSSIA-EO14024].
285929 STATE FLIGHT TEST CENTER (a.k.a. 929 GLITS; a.k.a. STATE FLIGHT
286TESTING CENTER NAMED AFTER V.P. CHKALOV), Akhtubinsk, Astrakhan
287Region, Russia; Khmeimim Air Base, Syria; Chkalovsky Airfield,
288Russia; Organization Established Date Oct 1920; Target Type
289Government Entity [RUSSIA-EO14024].
2901425 BRICKELL AVE 63-F LLC, 1425 Brickell Ave 63-F, Miami, FL
29133131, United States; Tax ID No. 71-1053365 (United States)
292[SDNTK].
2931425 BRICKELL AVENUE 64E LLC, 1425 Brickell Avenue 64E, Miami, FL
29433131, United States; Tax ID No. 90-1019707 (United States)
295[SDNTK].
2961425 BRICKELL AVENUE UNIT 46B, LLC, 1425 Brickell Avenue Unit 46B,
297Miami, FL 33131, United States; Tax ID No. 90-0865341 (United
298States) [SDNTK].
29911420 CORP., 5599 NW 23rd Avenue, Boca Raton, FL 33496, United
300States; 11420 NW 4 Street, Plantation, FL 33325, United States;
301Company Number 27-0746046 (United States) [VENEZUELA] (Linked To:
302SARRIA DIAZ, Rafael Alfredo).
3032904977 CANADA, INC. (a.k.a. CARIBE SOL; a.k.a. HAVANTUR CANADA
304INC.), 818 rue Sherbrooke East, Montreal, Quebec H2L 1K3, Canada
305[CUBA].
306@BLENDERIO_ENGLISH (a.k.a. @BLENDERIO_RUSSIAN; a.k.a.
307@MADEAMAZE_BOT; a.k.a. BLENDER.IO; a.k.a. BLENDERIO); Website
308https://blender.io; alt. Website https://blender.to; alt. Website
309http://blenderjkul472odyrnpmnirqgpzd3kms54jrrfycledrvvfbyj3wnqd.oni
310on/; Email Address blender.io@tuta.io; alt. Email Address
311adblenderio@tuta.io; Digital Currency Address - XBT
3123K35dyL85fR9ht7UgzPfd1gLRRXQtNTqE3; alt. Digital Currency Address -
313XBT 3Q5dGfLKkWqWSwYtbMUyc8xGjN5LrRviK4; alt. Digital Currency
314Address - XBT 3EPqGUw2q89pwPZ1UF8FJspE2AyojSTjdu; alt. Digital
315Currency Address - XBT 3LhnVMcBq4gsR7aDaRr9XmUo17CuYBV4FN; alt.
316Digital Currency Address - XBT 3F6bbvS1krsc1qR8FsbTDfYQyvkMm3QvmR;
317alt. Digital Currency Address - XBT
3183JHMz3mTna1gVCZSPp8NgRFiY7phkv5mA8; alt. Digital Currency Address -
319XBT 32DaxSzUhLBHY2WGSWQYiBSHnRsfQZrrRp; alt. Digital Currency
320Address - XBT 3MTRvM5QrYZHKo8gh5qKcrPK3RLjxcDCZE; alt. Digital
321Currency Address - XBT 34pFGsSYbWEritXncW9unZtQQE9dKSvKku; alt.
322Digital Currency Address - XBT 38ncxqt932N9CcfNfYuHGZgCyR85hDkWBW;
323alt. Digital Currency Address - XBT
3243F6bbvS1krsc1qR8FsbTDfYQyvkMm3QvmR; alt. Digital Currency Address -
325XBT 3MD3riFB6U8PykypF6qkvSj8R2SGdUDPn3; alt. Digital Currency
326Address - XBT 3JUwAS7seL3fh5hxWh9fu3HCiEzjuQLTfg; alt. Digital
327Currency Address - XBT 3EUjqe9UpmyXCFd6jeu69hoTzndMRfxw9M; alt.
328Digital Currency Address - XBT 3QEjBiPzw6WZUL4MYMmMU6DY1Y25aVbpQu;
329alt. Digital Currency Address - XBT
3303N3YSDvp4cbhEgNGabQxTN39kEzJmwG8Ah; alt. Digital Currency Address -
331XBT 3J19qffPT6mxQUcV6k5yVURGZtdhpdGr4y; alt. Digital Currency
332Address - XBT 33KKjn4exdBJQkTtdWxqpdVsWxrw3LareG; alt. Digital
333Currency Address - XBT 3GSXNXzyCDoQ1Rhsc7F1jjjFe7DGcHHdcM; alt.
334Digital Currency Address - XBT 3QJyT8nThEQakbfqgX86YjCK1Sp9hfNCUW;
335alt. Digital Currency Address - XBT
33635hh9dg3wSvUJz9vFk1FsezLE5Fx3Hudk2; alt. Digital Currency Address -
337XBT 3NDzzVxiLBUs1WPvVGRfCYDTAD2Ua2PvW4; alt. Digital Currency
338Address - XBT 3DCCgmyKozcZkFBzYb1A2x8abZCpAUTPPk; alt. Digital
339Currency Address - XBT 3MvQ4gThF4mmuo49p4dBNchcmFHBRZnYfx; alt.
340Digital Currency Address - XBT 3FBgeJdhiBe22UoSpp51Vd8dPHVa2A4wZX;
341alt. Digital Currency Address - XBT
3423HQDRyzwm82MFmLWtmyikDM9JQEtVT6vAp; alt. Digital Currency Address -
343XBT 31t4nEpcwyQJT1VuXdAoQZTT5givRDPsNP; alt. Digital Currency
344Address - XBT 39AALn7eTjdPzLb99hHhD6F7J8QWB3R2Rd; alt. Digital
345Currency Address - XBT 3LDbNuDkKmLae5r3a5icPA5CQg2Y8F7ogW; alt.
346Digital Currency Address - XBT 3JLyyLbwciWAC6re87D7mRknXakR4YbnUd;
347alt. Digital Currency Address - XBT
3483ANWhUnHujdwbw2jEuGSRH6bvFsD9BqEy9; alt. Digital Currency Address -
349XBT 32fbAZMTaQxNd2fAue1PgsiPgWfcsHBQQt; alt. Digital Currency
350Address - XBT 3HupEUfKmMhvhXqf8TMoPAyqDcRC1kpe65; alt. Digital
351Currency Address - XBT 34kEYgpijvCmjvahRXXQEnBH76UGJVx2wg; alt.
352Digital Currency Address - XBT 3GYbbYkvqvjF5oYhaKCgQYCvcVE1JENk6J;
353alt. Digital Currency Address - XBT
3543BazbaTP8ELJUEfPBV9z5HXEdgBziV9p7W; alt. Digital Currency Address -
355XBT 3GMfGEDYMTq9G8dEHet1zLtUFJwYwSNa3Y; alt. Digital Currency
356Address - XBT 38LjCapRrJEW7w2zwbyS15P9D9UGPjWS44; alt. Digital
357Currency Address - XBT 36XqYWGvUQwBrYLRVuegN4pJJJSPWL1WEu; alt.
358Digital Currency Address - XBT 37g6WgqedzZx6nx51tYgssNG8Hnknyj5nL;
359alt. Digital Currency Address - XBT
3603QAdoc1rDCt8dii1GVPJXvvK6CEJLzCRZw; alt. Digital Currency Address -
361XBT 32PsiT8itBrEF84ebdaF82yBUEcz5Wc6uY; alt. Digital Currency
362Address - XBT 3B4G1M8eF3cThbeMwhEWkKzczw9QoNTGak; alt. Digital
363Currency Address - XBT 34ETiHfQWEYFCCaXmEeQWVmhFH5vz2JMvd; alt.
364Digital Currency Address - XBT 3PyzSbFj3hbQQjTzDzyLSgvFVDjB7yw4Cj;
365alt. Digital Currency Address - XBT
36615PggTG7YhJKiE6B16vkKzA1YDTZipXEX4; Secondary sanctions risk:
367Ukraine-/Russia-Related Sanctions Regulations, 31 CFR 589.201;
368Organization Established Date 2017 [CYBER2].
369@BLENDERIO_RUSSIAN (a.k.a. @BLENDERIO_ENGLISH; a.k.a.
370@MADEAMAZE_BOT; a.k.a. BLENDER.IO; a.k.a. BLENDERIO); Website
371https://blender.io; alt. Website https://blender.to; alt. Website
372http://blenderjkul472odyrnpmnirqgpzd3kms54jrrfycledrvvfbyj3wnqd.oni
373on/; Email Address blender.io@tuta.io; alt. Email Address
374adblenderio@tuta.io; Digital Currency Address - XBT
3753K35dyL85fR9ht7UgzPfd1gLRRXQtNTqE3; alt. Digital Currency Address -
376XBT 3Q5dGfLKkWqWSwYtbMUyc8xGjN5LrRviK4; alt. Digital Currency
377Address - XBT 3EPqGUw2q89pwPZ1UF8FJspE2AyojSTjdu; alt. Digital
378Currency Address - XBT 3LhnVMcBq4gsR7aDaRr9XmUo17CuYBV4FN; alt.
379Digital Currency Address - XBT 3F6bbvS1krsc1qR8FsbTDfYQyvkMm3QvmR;
380alt. Digital Currency Address - XBT
3813JHMz3mTna1gVCZSPp8NgRFiY7phkv5mA8; alt. Digital Currency Address -
382XBT 32DaxSzUhLBHY2WGSWQYiBSHnRsfQZrrRp; alt. Digital Currency
383Address - XBT 3MTRvM5QrYZHKo8gh5qKcrPK3RLjxcDCZE; alt. Digital
384Currency Address - XBT 34pFGsSYbWEritXncW9unZtQQE9dKSvKku; alt.
385Digital Currency Address - XBT 38ncxqt932N9CcfNfYuHGZgCyR85hDkWBW;
386alt. Digital Currency Address - XBT
3873F6bbvS1krsc1qR8FsbTDfYQyvkMm3QvmR; alt. Digital Currency Address -
388XBT 3MD3riFB6U8PykypF6qkvSj8R2SGdUDPn3; alt. Digital Currency
389Address - XBT 3JUwAS7seL3fh5hxWh9fu3HCiEzjuQLTfg; alt. Digital
390Currency Address - XBT 3EUjqe9UpmyXCFd6jeu69hoTzndMRfxw9M; alt.
391Digital Currency Address - XBT 3QEjBiPzw6WZUL4MYMmMU6DY1Y25aVbpQu;
392alt. Digital Currency Address - XBT
3933N3YSDvp4cbhEgNGabQxTN39kEzJmwG8Ah; alt. Digital Currency Address -
394XBT 3J19qffPT6mxQUcV6k5yVURGZtdhpdGr4y; alt. Digital Currency
395Address - XBT 33KKjn4exdBJQkTtdWxqpdVsWxrw3LareG; alt. Digital
396Currency Address - XBT 3GSXNXzyCDoQ1Rhsc7F1jjjFe7DGcHHdcM; alt.
397Digital Currency Address - XBT 3QJyT8nThEQakbfqgX86YjCK1Sp9hfNCUW;
398alt. Digital Currency Address - XBT
39935hh9dg3wSvUJz9vFk1FsezLE5Fx3Hudk2; alt. Digital Currency Address -
400XBT 3NDzzVxiLBUs1WPvVGRfCYDTAD2Ua2PvW4; alt. Digital Currency
OFAC_EU_Merge
Cell Formulas
RangeFormula
C6:C7C6=A6
D6:D12D6=FuzzyVLookup(C6,$A$6:$A$4091,1,$D$2,1,2)
C8C8=A15
C9C9=A21
C10C10=A25
C11C11=A28
C12C12=A22
Named Ranges
NameRefers ToCells
Clear_OFAC_EU_Merge=OFAC_EU_Merge!$A$6:INDEX(OFAC_EU_Merge!$A:$A,COUNTA(OFAC_EU_Merge!$A:$A)+1)D6:D12, C6
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
Sorry, it did work for 4000 rows but not for 230,000.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Problem with running 2 different macros
Replies
5
Views
933
pupsia
P

Forum statistics

Threads
1,223,837
Messages
6,174,927
Members
452,593
Latest member
Jason5710

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top