Results 1 to 9 of 9

Need help with max formula!

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2017
    Location
    US
    MS-Off Ver
    2016
    Posts
    8

    Need help with max formula!

    Max.png



    I am currently running a timed experiment where I have a column of increasing times (column A) with a set of values (column C) recorded at those times. The software I am using generates 3-5 data points per second and I have ~50,000 rows I really (REALLY) want to sift through with a formula instead of manually. I would have to scroll through 100 pages to manually select a range

    Basically, I want to define a range of times using a upper/lower limit (column A), and obtain the max value of column C within that time range.

    ________
    e.g. at 14:04:59, a drug dose is given to measure a response that has a peak before the next dose is given at 14:15:11. I want to find that peak (i.e. max) value.

    So, between the times 14:04:59 and 14:15:11 (represented in column A), I want to find to find the max in column C within that reference range. 14:04:59 would define the lower limit and 14:15:11 would define the upper limit of that range in column A.


    Thanks in advance! First time poster here.
    Attached Files Attached Files
    Last edited by aupa; 05-30-2017 at 11:07 PM. Reason: clarification

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  2. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  3. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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