Jul 18 2019 10:06 PM
Hi,
I have a large data set, which the name differs slightly. Is there a way i can match the two.
Example match:
State Street Australia Ltd ACF EQT ATF Alpha Global Opportunities Fund
Alpha Global Opportunities Fund
Thank you for your assistance.
Jul 19 2019 02:24 AM
Could you provide few more sample data.
Looking at your example a following function should do the job.
=ISNUMBER(FIND(B2,A2))
A2 = State Street Australia Ltd ACF EQT ATF Alpha Global Opportunities Fund
B2 = Alpha Global Opportunities Fund