Finding the Cell Reference for the minimum value of a data list.

  • Thread starter Thread starter Matt Yackel
  • Start date Start date
M

Matt Yackel

I am trying to figure out how to automatically refernce a
location of a cell (ex. C5)which has been calculated to be
the minimum value of a set of data.

If I can reference the row of this cell absolutely, then I
want to use that value as the beginning data reference
point for both the X and Y data values of an XY scatter
plot.
 
You can reference it using the MATCH function with INDEX or OFFSET:

I.e., the starting cell might be referenced as:

INDEX(C:C, MATCH(MIN(C:C),C:C, 0))

while the range to plot could be referenced as:

OFFSET(C1,MATCH(MIN(C:C),C:C, 0)-1,0,numrows,numcols)
 
Back
Top