I have a running app which collects data, and displays it in excel. 96 data points in a 24 hour period, this is one set of data, and I have 48, so to sum up 48 rows of data, each row with 96 data points in.
For some reason the data has started to peak and trough massively in certain parts, is there a formula that will look at a row of data be able to find these peaks and troughs and alter them to fit within the general feel of the numbers
Posted by bradrz_2000 on
There are currently no replies to the "formula to alter results in a dataset" topic of the Excel Help Forum for Analyzing Corporate Financial Data.