Dear all expects
I’m very annoying that the too many address to find same address to sort and printout to an employees’
But the address are different format how can I asked help it if VBA / MACROS can help ?

What I looking for help :
COL D ( Address format like that )
Row 1 6F EVERGAIN BLDG. 21-23 RMA CENTER-QRA LAB
Row 2 HK TEST CENTER 6F,EVER GAIN BLDG

Can vba do if part of 60% are same than Row 2 = Row 1 . value ?


Just thinking it & highly appreciate your help.