Em Andamento

Do some Excel Work

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.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Visual Basic

Ver mais: macros work excel internet, freelance work excel vba, track work excel, contract work excel access, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

Acerca do Empregador:
( 13 comentários ) Melbourne, Australia

ID do Projeto: #11754425

Premiar a:

Tanmoy236

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 majori Mais

$30 USD em 1 dia
(67 Avaliações)
5.7

13 freelancers estão ofertando em média $29 para este trabalho

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD em 1 dia
(103 Comentários)
6.2
rohitpithisaria

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 Mais

$30 USD em 1 dia
(73 Comentários)
5.8
sadekhosen77

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 Mais

$25 USD em 1 dia
(23 Comentários)
4.6
DataShu

contact me sir i can do this........................................................................

$25 USD em 1 dia
(26 Comentários)
4.5
kvosaravana

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 Mais

$20 USD em 1 dia
(21 Comentários)
3.8
fixen2011

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

$25 USD em 1 dia
(3 Comentários)
1.9
MECHATRONS

Hello,We are a team of developers and do all work related to computer science( Software Engineering ),. We have experience in , JAVA,C# ,My SQL , website Design( wordpress ,PHP), Excel, ( vb ,(macro)), Data Entry, Grap Mais

$25 USD em 1 dia
(0 Comentários)
0.0
harunur93

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 f Mais

$25 USD in 5 dias
(0 Comentários)
0.0
nethaganesh

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 Pro Mais

$25 USD em 1 dia
(0 Comentários)
0.0
hasratkhan009

i can do your work according to your requirements.i hope you will like my work,.just give me chance to complete your work properly.

$55 USD in 2 dias
(0 Comentários)
0.0
sivaihvf

A proposal has not yet been provided

$10 USD in 2 dias
(0 Comentários)
0.0
$30 USD em 1 dia
(0 Comentários)
0.0
$29 USD em 1 dia
(0 Comentários)
0.0