inneedforexcelhelp
New Member
- Joined
- Aug 29, 2017
- Messages
- 1
Hi,
I'm stuck on a list with 1 column consisting of 13000 company names. These company names some are partial matches. For example, Company ABC Pty Ltd. and Company ABC Proprietary Limited.
Is there anyway for me to be able to filter through this? Even a macro ...anything.![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I only have 1 column and all I've found is comparing with 2 columns, I know you can do that with a Fuzzy Lookup.
Any help would be much appreciated.
Thanks!!![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I'm stuck on a list with 1 column consisting of 13000 company names. These company names some are partial matches. For example, Company ABC Pty Ltd. and Company ABC Proprietary Limited.
Is there anyway for me to be able to filter through this? Even a macro ...anything.
I only have 1 column and all I've found is comparing with 2 columns, I know you can do that with a Fuzzy Lookup.
Any help would be much appreciated.
Thanks!!