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.
45 freelancers estão ofertando em média $25 para este trabalho
Hello,I can start right now. I would like only to see 1 [url removed, login to view] kind of fond do you prefer etc. I work fast and I am concentrated on details . You can rely on my work. Please see my portfolio. Best regards Alicja
Ready to start. Please give me a chance. I would try to complete the project with accuracy. I assure you that you would not be disappointed with my work. Thanks.
I am available and can start immediately. I am experienced, will stick to schedules, and generally a perfectionist. II am quick learner and will be able to handle job on my own.
Hi, if you will give me a sample, I assure you that I will finish your work with the desired accuracy within the desired time. Looking forward to hearing from you.
excel is 1 if my skills. this work will done in 2 days time as it just a simple task. with the price and time i bid for, will result good outcome as per request.
HI [url removed, login to view] SO EXICTED TO HAVE JOIN THIS AWSOME [url removed, login to view] LOOKING AT YOUR PROJECT AND DOWNLOADING YOUR SAMPLE FILE I START WORKING ON IT [url removed, login to view] HAPPY TO SAY AFTER SPENDING A FEW HOURS I MANAGE TO AUTOMATE THE PR Mais