+ Reply to Thread
Results 1 to 4 of 4

How to retrieve a value from a dynamic range.

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Lightbulb How to retrieve a value from a dynamic range.

    Sorry if the title is unclear, I didn't want to be too specific.

    So my problem is:

    I have (a lot of) raw data that translates into graphs with a single peak (climbing from 0 to max value) and thereafter dipping into a minimum and climbing back up again.

    Simplified such data would look like this:

    x y
    0 0
    1 3
    2 8
    3 15
    4 8
    5 6
    6 5
    7 6
    8 7
    9 8

    I want to have a cell to return the minimal "y" value (5) from the range AFTER the maximal "y" value (15) (the plateau minimum).

    So I need a function to look up the maximal "y" value, defining a range from that cell to the end of the data and giving me the minimum from that set range.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to retrieve a value from a dynamic range.

    Hi,

    =MIN(B11:INDEX(B2:B11,MATCH(MAX(B2:B11),B2:B11,0)))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Re: How to retrieve a value from a dynamic range.

    That did the trick. Thanks!

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to retrieve a value from a dynamic range.

    You're welcome!

+ 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. Match ComboBox with dynamic range, then add Textbox1 to dynamic range
    By Lasse Moe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 01:26 AM
  2. Replies: 3
    Last Post: 01-06-2014, 01:22 PM
  3. Fill Dynamic Range From Dynamic Source Range
    By goss in forum Excel General
    Replies: 2
    Last Post: 03-06-2012, 12:05 PM
  4. Way to retrieve values from a dynamic named range?
    By OLDWEASEL in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-08-2011, 09:53 AM
  5. Retrieve individual cells from a range changed between a range
    By baldomero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2005, 02:31 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