Lowest value in a selection of data

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

What formula would I use to find the lowest value in a selection of
data i.e. B49:E52.

Much Appreciated

Brian
 
Jumping in here...

Is it possible to know the address of the cell containing the minimum
value?

John.
 
You can use the MATCH function to locate the (relative) position, but
if you have more than one value which are minima then it will only
find the first.

Pete
 
Back
Top