Data Processing in Excel.
Notes: MUST be 2010 or above
Must have a fast computer with lots of RAM. These sheets have 300,000 rows
Must know what #N/A and #REF means in Excel.
I've included a Template Excel (processed) excel file. Two tabs, 1 data tab and 1 chart. The formulas should be relatively simple, however, many use #N/A and #REF in their functions.
I have 10 CSV files, where the data needs to be pasted into column 1&2 of the data tab. When I do it, some of the formulas get messed up and the chart series needs to be updated. With the copy/paste with the appropriate shift/ctrl or changing A1 to $A$1 for example,. this should be quick.
I need 10 total excel files produced to match the 10 CSV files based on the template.
Please open the template before bidding.
32 freelancers are bidding on average $25 for this job
Hi, Excel expert here. I will get this done in a few hours. Thank you P.S : I've Excel 2007. But its quiet enough for this project :) Not sure why you need 2010 :(
Hi, firstyou need to provide the third parameter of the Aggregate function (that parameter appears to have been lost while you were performing some basic actions like cut, insert, etc)
Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [url removed, login to view]