Home > Forum Home > Analyzing Corporate Financial Data > formula to alter results in a dataset Share

Formula to alter results in a dataset

Excel Help for Formula To Alter Results In A Dataset in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Formula To Alter Results In A Dataset

Rate this:
(3/5 from 1 vote)
ConfusedHello, I am in need of much help.

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

thanks

 Posted by 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.

Post Reply

Find relevant Excel templates and add-ins for formula to alter results in a dataset in the