Formula help
 

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

Formula help
 

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


"Meejung" wrote in message
...
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

Formula help
 

=MIN(A1:A10)
--
Gary''s Student - gsnu200901


"Meejung" wrote:

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

Formula help
 

"T. Valko" wrote:

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


"Meejung" wrote in message
...
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


Thanks to both of you for the very quick response. This is exactly what I was looking for.

Formula help
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


"Meejung" wrote in message
...
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


Thanks to both of you for the very quick response. This is exactly what
I was looking for.

Formula help
 

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

Thanks,
Shelli

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


"Meejung" wrote in message
...
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


Thanks to both of you for the very quick response. This is exactly what
I was looking for.

Formula help
 

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)


"Meejung" wrote in message
...
I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


"Meejung" wrote in message
...
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


Thanks to both of you for the very quick response. This is exactly
what
I was looking for.

Formula help
 

"Rick Rothstein" wrote:

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)


"Meejung" wrote in message
...
I got that one to work. Is is now possible to find the next lowest number?

Thanks,
Shelli

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meejung" wrote in message
...


"T. Valko" wrote:

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


"Meejung" wrote in message
...
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


Thanks to both of you for the very quick response. This is exactly
what
I was looking for.




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.