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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset and Small functions with blank rows? 0
Lowest number excluding zero 2
Value match with an array 1
in a single worksheet,hw to match values based on 2 list 2
The lowest of all? 6
Last value in column... 5
Remember Lowest Value in Cell 4
Custom Formula Requires Custom Formatting 2

Back
Top