Lowest value in a selection of data

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
 
J

John Google

Jumping in here...

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

John.
 
P

Pete_UK

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
 
Top