In Excel 2010, I need to analyse data. The data is time stamped, i.e column A contains data in the format dd/mm/yyyy hh:mm:ss. Column B contains values
I want to look at the data in column B and determine:
* how many times data exceeded a specific value.
* the time period the data exceeded the specific value. i,e The data exceed the specific value at this time (Column A) and returned >= to the specific at at this time (Column A), therefore it was out of range for "X" time
How would I do this?
Bookmarks