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.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
I am ready to be hired by you for the post of Articles Writer or Graphic Design Artist. I have all the skills and experience that makes me a competitive candidate for this post. I have had an ideal prospect and am ready to accept any new challenges that may be put in front of me. If given an opportunity to work for your company I will fulfil the given work with utmost dedication and loyalty. I have many years experience working as a Articles Writer and Graphic Design Artist. I am ready to start working for you today. I interested in other task too.
a student finds typing job
Cloghan, United Kingdom
With a background in international politics and international history I have improved my research skills, having also traced family history and am always on the lookout to further enhance my expertise through experience. Not afraid to grit my teeth and get down to work I will try to produce any information and/or provide services pertaining to copy-editing and proofreading to the best of my ability. Advanced knowledge of copy editing and proofreading with a background in business communication and academic writing. I have in the past taught canoeing in America to young children and this taught me to continually assess and reassess environments, to notice little things and correct them as well as creating different ways to help others learn according to their abilities. I have a background in debating and public speaking and have won several competitions with the speeches I have written and edited many times. I do not stop editing until I am happy with the end result, otherwise I will not put my name at the end of it. If I am unsure of anything I will ask, I will not assume. I work from time to time for a family computer software business depending on the task they need help with. It was through this that I began to realise my attention to detail and had a eye for problem solving with databases. During my time as Treasurer of Aberystwyth University Sailing Club I not only represented the club as a team member as events but organised with the social secretary events to raise money for new equipment, most importantly a safety boat (of which we had none), as well as working, and succeeding in doing so, to get the club out of financial difficulty, from being heavily in the negative to being of sufficient strength to look at expanding its current fleet whilst affording bills.
My Team and myself is an offsource Media Center, which does work for clients interested in Copy Writing, SEO , Remote IT Assistance and others. We are professionals in Accounting / Excel and related Software. We are new on Freelancer, but you can view our Fb page on www.facebook.com/wnetworx
Shah Alam, Malaysia
Over 5 years of responsible experience as an Administrator with a proven record of accomplishment in the areas of data entry, research assistant, writing reports, editing and compiling journal. I'm a professional user of office (Word, Excel, PowerPoint) and basics in SPSS and N Vivo software system for research analysis. I also have basic experience in SAP (End-User).
Data entry, excel, ppt, solutions & service
C++, Excel, Albanian
A new member here but a full time dedication is guaranteed with me. Can give maximum time to your work and will do it like my own work.
JOHANNESBURG, South Africa
IF YOU ARE A: GOOD COMMUNICATOR COMMITTED THAN YOU ARE BOUND TO FIND THE SOLUTION TO ALL YOUR: DATABASE SOLUTIONS MS ACCESS MS SQL SEVER 2008 MS SQL SERVER 2008 BI MS EXCEL MS VBA LET'S START TODAY-FORWARD!