+ Reply to Thread
Results 1 to 5 of 5

Get Local Minimum, Maximum Values

Hybrid View

  1. #1
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Get Local Minimum, Maximum Values

    Like this?

    A
    B
    C
    D
    1
    Date
    Value
    2
    01/02/2009
    30.53
    3
    01/05/2009
    30.39
    min C3 and down: =IF(B3=MAX(B2:B4), "max", IF(B3=MIN(B2:B4), "min", ""))
    4
    01/06/2009
    30.63
    max
    5
    01/07/2009
    29.73
    min
    6
    01/08/2009
    29.82
    max
    7
    01/09/2009
    29.19
    8
    01/12/2009
    28.53
    min
    9
    01/13/2009
    28.58
    max
    10
    01/14/2009
    27.64
    min
    11
    01/15/2009
    27.66
    12
    01/16/2009
    27.88
    max
    13
    01/20/2009
    26.41
    min
    14
    01/21/2009
    27.56
    max
    15
    01/22/2009
    27.14
    min
    16
    01/23/2009
    27.28
    Last edited by shg; 11-20-2013 at 03:24 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional maximum and minimum values
    By metsci in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2013, 11:35 PM
  2. pulling out minimum and maximum values..!
    By via135 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-04-2011, 11:05 AM
  3. Maximum & Minimum values in a coulmn
    By balmalik in forum Excel General
    Replies: 7
    Last Post: 07-21-2006, 05:35 AM

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