find only two lowest values in column

[riaosu]

I need to find the two lowest values in a column that only has positive values and no zeros.

 

[Andrew Poulsom]

For the smallest you can use MIN. For the second smallest you can use SMALL.

 

[T. Valko]

I need to find the two lowest values in a column that only has positive values and no zeros.

Try this...

Book1
	A	B	C
2	18	_	8
3	8	_	14
4	95	_	_
5	38	_	_
6	27	_	_
7	35	_	_
8	36	_	_
9	14	_	_
10	80	_	_
Sheet1

This formula entered in C2 for the smallest value:

=MIN(A2:A10)

This formula entered in C3 for the 2nd smallest value:

=SMALL(A2:A10,2)

Or, you could enter this formula in C2 and copy down to C3:

=SMALL(A$2:A$10,ROWS(C$2:C2))

 

[riaosu]

Many thanks--suggestions work perfectly for this rookie.

 

[T. Valko]

Many thanks--suggestions work perfectly for this rookie.

You're welcome. Thanks for the feedback!