codenameSRJ
New Member
- Joined
- Jun 25, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Dear Altruist,
I hope you are doing well in this pandemic situation. Recently I'm working as an audit assistant in an audit firm. My colleague sent me a file regarding the address of several branch offices of an Insurance company. The attached file shows several branch offices in two different columns. The sheet is very large so I just upload the first page.
My requirement is to identify similar branch office from B and M column. For example, B2 Bogra is similar to M2. Both the column consists of 1300 branch. So it is difficult for me to identify it one by one.
Is it possible to make any formula or other ways to identify similar names? Thanks In Advance.
I hope you are doing well in this pandemic situation. Recently I'm working as an audit assistant in an audit firm. My colleague sent me a file regarding the address of several branch offices of an Insurance company. The attached file shows several branch offices in two different columns. The sheet is very large so I just upload the first page.
My requirement is to identify similar branch office from B and M column. For example, B2 Bogra is similar to M2. Both the column consists of 1300 branch. So it is difficult for me to identify it one by one.
Is it possible to make any formula or other ways to identify similar names? Thanks In Advance.