Use some macros or formulas to clean the data in my workbook.
I have a workbook with 45288 rows in it.
There are only a few column.
I require someone to:
Duplicate the Author Metadeta column, so that there is an Author Metadata column as well as an Author column.
Then, in the new Author column, someone will need to run some formulas or scripts to make sure that there is only one name in there.
For example, some fields have the illustrator's name along with the authors name:
i.e H. de Graffigny; illustrated by Ferdinand Raffin
this should be changed to only H. de Graffigny
Most of the data can be delimited by semicolon, comma, full stop etc. However, not all of the data is like this and someone will need to carefully check that there is only ONE NAME in the Author field.
If you see a field that has DUPLICATE or SKIP in the workbook you can move on to the next row. The DUPLICATE or SKIP field is shown in red and replaces the title's name.
I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 90 works on Freelancer where majority of the works I got all 5 star rating and the employer was extremely happy with my work. I believe I can do a fantastic work for you if you provide me the opportunity.
About me:
I am a Business (BBA) Graduate with major in FINANCE and MARKETING along with 4 years of experience in Sales, Marketing and Copy writing. Currently I am working for a Multinational Telecommunication Company in the Marketing and Analysis Department as an Assistant Manager.
My profound academic knowledge along with my professional experience will significantly help to deliver the best work and therefore see a completely satisfied 'YOU'
[login to view URL]
$30 USD en 1 día
4,9 (277 comentarios)
7,2
7,2
12 freelancers están ofertando un promedio de $29 USD por este trabajo
Hello...
I am highly interested to do your project.
I beleive that, I can do this work properly and in timely by your instruction.
Always determined to give you a best work.
Moreover, I have a group which consist of 5 members.
Thanks
Hello
I am an excel expert and would like to bid on the project posted by you.
I have completed more than 100 projects in excel.
FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work.
Rgds
Rohit Pithisaria
Respected Sir,
I am interested in your project. I have excellent Microsoft Excel and VBA programming skills which will be of excellent value for your project. I understand your project need. You have a Excel spreadhseet with long rows, which needs to processed either using formula or VBA scripts. I can help you with my good understanding of Excel formula and VBA programming.
I can complete your assignment quickly and with good data accuracy and clarity. I assure you my complete support and service. Please consider my proposal and discuss with me your detailed requirements. You can pay me after my successful and satisfactory completion of your work.
Thank you
Yours faithfully
Saravana Prakash
Hi Sir,
I have a previous project same with you where he's number of row data where over 16000.
I really believe I can help you.
Can you provide me the excel file ? :)
Best regards,
Flora
Hi There,
i understand your requirements and i can do it exactly. though i am new in freelancer.com but i have done few task in upwork.com. fell free to contact with me.i have done few job in upwork.
looking forward to hearing details from you.
Best,
Hi,
This is Ganesh Netha from Hyderabad. I've gone through your business proposal. and understood the overview. I wanted to work with you on this project.
I was working for different US based processes as a Process associate since 2010. Got pretty good experience on handling huge data workbooks, data entry, US health claims, Provider records etc. Experienced enough to work under 100% accuracy conditions. I can fulfill all your SLAs within the expected time.
Hope, I will exceed your expectations.
Thank you.