We need to mark errors on a list of 5100 companies for review. This includes companies that appear more than once with variations of name and companies that do not fit the naming convention.
For every line in file, search to see if the name in column B (Account Name) appears again in other lines with variation. If true, mark "Yes" on column D and write in column E the name it appeared with first. If false, check if the name has the word " - Parent" as an appendage in the end. If not, mark "Yes" in column F.
For example -
The company in line 6 "Cisco" has a duplicate in line 4861 where its written as "Cisco Systems Inc." and in line 4880 where its listed as "Cisco France". For these 3 and any other duplications, you would mark "Yes" in column D on the same line and in column E write "Cisco".
For the company in line 2 "Wells Fargo Bank" there appears to be no duplicates but the name does not have the word "- Parent" appended at the end. In this case you will mark "Yes"
41 freelancere byder i gennemsnit $145 på dette job
i did similar work in the past and i have few ideas of how to get this done quickly and more accurtely, since names will be confusing, can we talk thx
I am ready to clean and update your 5100 companies database in excel as requested. And also will Yes and no. Can you please send me whole DB file? Ready to do first 20 rows for sample. Lets chat. Thank You
Hi there, I can do cleansing a database of companies from duplicates and inconsistencies. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Dear Client, I ensure I will complete the task successfully and within the specified time. I love perfection in work. So I ensure the work will be spot on. Your satisfaction is my success. Kindly contact me. Roy
Hello, I can identify and mark if companies that appear more than once with variations of name and companies that do not fit the naming convention. Let’s discuss if you’re interested. Best regards, Duong
Hello there, I'm interested in your project. I have a few questions about your project Please send me a message so that we can discuss more. Regards Ramveer
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can discuss further.