Formula help

  • Thread starter Thread starter Meejung
  • Start date Start date
M

Meejung

Is there a formula which will search for the lowest number in a range and
will put that value into another cell which can then be auto summed?

Thanks,
Shelli
 
This will return the lowest number from the range A1:A10:

Entered in any cell *other than* A1:A10 -

=MIN(A1:A10)
 
T. Valko said:
This will return the lowest number from the range A1:A10:

Entered in any cell *other than* A1:A10 -

=MIN(A1:A10)

--
Biff
Microsoft Excel MVP





Thanks to both of you for the very quick response. This is exactly what I was looking for.
Click to expand...
 
I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli
 
If your real question is how to find the nth smallest value in a range, then
don't use the MIN function, use the SMALL function instead.

This is identical to the MIN function...
=SMALL(A1:A7,1)

This finds the 2nd smallest value in the range...
=SMALL(A1:A7,2)

The first argument is the range to search and the second argument is which
smallest number to find. There is a corresponding LARGE function which works
for the nth largest value in a range.
 
Rick Rothstein said:
If your real question is how to find the nth smallest value in a range, then
don't use the MIN function, use the SMALL function instead.

This is identical to the MIN function...
=SMALL(A1:A7,1)

This finds the 2nd smallest value in the range...
=SMALL(A1:A7,2)

The first argument is the range to search and the second argument is which
smallest number to find. There is a corresponding LARGE function which works
for the nth largest value in a range.

--
Rick (MVP - Excel)




Rick,
Click to expand...

Thank you. My original question was how to find the smallest. I had
another issue come up which required me to find the second smallest and so
on. Thanks for the help.
 
Back
Top