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 estão ofertando em média $25 para este trabalho
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)