Excel Spreadsheet Data sort with totals on summary
Budget: £10 – £20 GBP
I have a spreadsheet with over 500,000 lines of data relating to approximately 1,150 sites
Each line is a days data for a site and I require the data summed for each site along with a few other stats for each site on a summary sheet.
If the data is altered, the summary must also update.
The file is over 200mb and can be stared via link.
Example PDF is attached.
Each line is a days data for a site and I require the data summed for each site along with a few other stats for each site on a summary sheet.
If the data is altered, the summary must also update.
The file is over 200mb and can be stared via link.
Example PDF is attached.