Formula help

[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

 

[T. Valko]

This will return the lowest number from the range A1:A10:

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

=MIN(A1:A10)

 

[Gary''s Student]

=MIN(A1:A10)

 

[Meejung]

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.

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Meejung]

I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli

 

[Rick Rothstein]

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.

 

[Meejung]

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,

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.