Results 1 to 10 of 10

Find number of instances data is with with a range

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    Mbabane, Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    29

    Find number of instances data is with with a range

    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?
    Last edited by TimTDP; 10-13-2011 at 10:18 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1