Cancelado

Synchronize Rows in Excel - repost

I have 39 excel files, in each file, there are 4 columns with data , about 3500 rows. The first 2 columns are Date and Price, the second 2 are Date and Index.

I need someone to synchronize the files, so that the dates are the same with the numbers for price and index. Now some of the cells are empty, or with *, or sometimes there is Index info but no Price info. I want only rows where there is both Index and Price. The other should be deleted. All data must be accurate as its now. Only manipulation should be done, so rows where Index or Price doesn't exist, to be removed. I also need report on which rows were deleted for each of the files (with the row info before that).

I will double check the files to make sure it all fits. I attach here example file.

Only the Tables with- "True" in the name, should be manipulated.

Don't bid if you don't understand 100%, what's the task. Message me if you have questions.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Ver mais: double data entry excel, synchronize, rows, excel synchronize rows, synchronize rows excel, check data excel files, fix excel, check excel files, excel check double, synchronize rows excel repost, check data entry report, excel file data manipulation, index excel, synchronize file, report check data entry, excel manipulation, check report data entry, price file excel, data report excel, data entry true, need someone fix excel, excel row columns, rows excel, tables excel, check entry excel

Acerca do Empregador:
( 0 comentários ) Kalawana, Sri Lanka

ID do Projeto: #5108819

38 freelancers estão ofertando em média $24 para este trabalho

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: http://sigma-dns.sigmavirtual.com/PDemo1/Am Mais

$103 USD in 3 dias
(30 Comentários)
5.9
EgyProgramer

A proposal has not yet been provided

$15 USD in 0 dias
(14 Comentários)
4.1
zExcel

If this can be done with formulas or macro I'll be happy to do it for you. But if you are looking for manual data entry I will pass

$35 USD em 1 dia
(12 Comentários)
4.1
Naumaan

Hi Rohana, Thanks for the project. I am online here today. Kindly send me excel sheet. Regards Nauman Pervez ex-employee Etilize GfK Data quality checking, editing, extraction and research http://n Mais

$30 USD em 1 dia
(6 Comentários)
3.4
cdumitru

A proposal has not yet been provided

$25 USD in 3 dias
(5 Comentários)
3.2
Aldo21

Hi, I've just done something similar to another guy, here are the files to be merged into one. First download all files in the same folder. then Open the mastersheet file and clic on import data, then you select the fi Mais

$10 USD em 1 dia
(7 Comentários)
2.9
Kalanui

Hi there, I would like to bid for this project. This will be done via the following method: 1) Initial check of the two date files to ensure they are formatted correctly within excel as 'date' fields and not as Mais

$25 USD em 1 dia
(1 Comentário)
2.3
monish2002

Hi. Thanks for the opportunity extended. I understand the project needs and find myself confident to carry out the work in the stipulated time frame. What differentiates me from my competitors is the consistenc Mais

$20 USD in 2 dias
(3 Comentários)
1.1
Teamm

I am excel proficient ( formulas and vba) and have a reputation of completing assignments on time as of user requirements.

$25 USD in 2 dias
(1 Comentário)
1.0
mailsmaity

Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - mail.smaity

$19 USD in 3 dias
(1 Comentário)
0.6
rbaby9

Hi, I am an MIS expert with 5 years of experience in dashboard creation, VBA Macro and Analytics. My daily tasks include data scrubbing and major collations from stream files over ShareDrive. Would be able to Mais

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

Hello sir i understand your needs, and i am happy to work with you. btw sir, i cannot see your attachement. thanks,

$10 USD in 2 dias
(0 Comentários)
0.0
gekados

Propunerea nu a fost încă furnizată

$10 USD em 1 dia
(0 Comentários)
0.0
Tash007

I have 12 years of excellent work performance and work with excel spreadsheets. Give me a chance and you won't regret it. Many thanks. Natasha

$25 USD in 3 dias
(0 Comentários)
0.0
allsopnigel

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
0.0
carlandsazza

For each file: check to see if row contains both a price and index. If not it will be flagged and moved to a separate page. next stage will be to check the dates are the same. If not, then I would need instruct Mais

$20 USD in 3 dias
(0 Comentários)
0.0
acikyardjr

A proposal has not yet been provided

$35 USD em 1 dia
(0 Comentários)
0.0
yprakasarao

I am ready to do this work for the minimum amount as i am interested to join the professionals of freelancers.

$10 USD in 3 dias
(0 Comentários)
0.0
elnick

Δεν έχει γίνει καμιά πρόταση ακόμα

$25 USD in 2 dias
(0 Comentários)
0.0
anigre

A proposal has not yet been provided

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