Company Duplicate Identification and MTAuID Assignment
Budget: $10 – $30 USD
I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules.
Key Requirements:
- Identify duplicate companies based on their Business Name
- Assign different MTAuIDs to Joint Ventures
- Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions
The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business.
Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.
Key Requirements:
- Identify duplicate companies based on their Business Name
- Assign different MTAuIDs to Joint Ventures
- Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions
The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business.
Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.