Em Andamento

Synchronize Rows in Excel

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, Excel

Ver mais: synchronize rows excel, excel synchronize rows, synchronize, rows, check data excel files, check excel files, excel check double, excel data tables, excel file data manipulation, index excel, synchronize file, excel manipulation, price file excel, excel data columns, excel row columns, rows excel, tables excel, check date excel, report excel data, excel workload tracking example, vba excel rows html, excel product sheet example, excel price example, 100 name excel, data manipulation excel

Acerca do Empregador:
( 19 comentários ) Belize, Bulgaria

ID do Projeto: #5108224

Premiar a:

Arty182925

Hi there. This is easy for me and I can do it fast. I would like to send you your file back but you need to contact me. I had plenty of this kind of job on my fiverr page. If you want I can do this for you in Mais

$15 USD em 1 dia
(0 Avaliações)
0.0

32 freelancers estão ofertando em média $25 para este trabalho

mrbrave

I have done a sample file you have attached. Please download from here.. https://www.dropbox.com/s/hn7za2rd4rne71a/coffee-cont.xls Output sheet Column B-D has data you required.Other two columns are helper colum Mais

$24 USD em 1 dia
(110 Comentários)
5.8
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than Mais

$29 USD in 2 dias
(29 Comentários)
5.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$30 USD in 3 dias
(20 Comentários)
4.8
expertatwork

hey ilipoo1, please correct me if wrong -> Only the dates which match should remain (columns A,C). Rest of them should be removed. Correct ? Meanwhile - which OS are you using- MAC or WINDOWS. please reply. thanks !

$25 USD in 3 dias
(43 Comentários)
4.6
Ibrahim185

sir, i am highly interested and dedicated to do this task. let's start. i am awaiting for your positive reply. thanks

$30 USD in 2 dias
(26 Comentários)
4.5
microk

Dear itipoo1, Expert here.. Please award project. Bid: $28 Timeline - 1 day Regards, Microk http://www.extremeexcelsolutions.weebly.com

$28 USD in 3 dias
(27 Comentários)
4.4
katepesic

Hi, I have experience in job like this and I can do this job very fast, please contact me for details

$30 USD em 1 dia
(25 Comentários)
4.3
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mais

$25 USD in 3 dias
(22 Comentários)
4.2
vietitdotinfo

Hi. I can do this in about 1 hour. I have done alot of similar project. Input excel and write back or export to a new file. I am ready to do for you. You will have the best result. Thanks!

$25 USD in 0 dias
(7 Comentários)
3.6
MRDzA

PLEASE, CONTACT US FOR MORE DETAILS -------- www.vzstudio.me ------- Dear Sir/Madam, I am offerring you our services. You will have unlimited revisions and guaranteed quality as result. If you are not sattisfied with Mais

$30 USD in 5 dias
(1 Comentário)
3.4
dviruki

Hi! I understand what needs to be done and can do it. I'll write a VBA macro to automate and speed up the process and avoid errors. I have 12 years of extensive Excel and VBA experience.

$27 USD in 0 dias
(12 Comentários)
3.3
quatroo

I can help you within hours and with 100% accuracy. Please let me know if you're interested. Regards, quatroo

$25 USD in 0 dias
(4 Comentários)
2.9
gianglh2011

Hi. I have read carefully and totally understand the requirement for the task. I'm a very careful and industrious worker. I can assure you I will finish it with 100% accuracy. I would appreciate it if you could conside Mais

$27 USD in 3 dias
(6 Comentários)
2.8
cvosinc

Hello, I have 15 years of administrative experience and excellent Excell skills. I can do this job for you in about an hour. Thank you for your consideration.

$30 USD em 1 dia
(1 Comentário)
1.8
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

$14 USD em 1 dia
(1 Comentário)
0.6
MaxTech3

ok i can do it......i read ur file but also it have some viruses, thats why my system gives warning before editing..u can later discuss..

$25 USD in 4 dias
(1 Comentário)
0.0
rahuls286

hi, Can complete it with 100% accuracy. Do have 3 yrs work experience in excel. Completed engineering & MBA, which will help to add more value to project. Project Requirement :- -- Synchronizing columns from Mais

$25 USD in 3 dias
(1 Comentário)
0.0
dhanushikak

I am a Copy Typing Freelancer and have ample knowledge and experience in this field. I have the power and ability to work honestly and reap in benefits for the company. Over the years I have worked for numerous employe Mais

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

http://www.claudia-morgan.com/wp-content/uploads/2010/08/I-Can-Do-It.jpg As cheesy as it sounds ha!

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

Hi ilipoo1, I understood your requests. I work with Excel daily and I can do the job. Best Regards, Marco Consorti

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