# find only two lowest values in column

#### riaosu

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

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
For the smallest you can use MIN. For the second smallest you can use SMALL.

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

Book1
ABC
218_8
38_14
495__
538__
627__
735__
836__
914__
1080__
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))

Many thanks--suggestions work perfectly for this rookie.

Many thanks--suggestions work perfectly for this rookie.
You're welcome. Thanks for the feedback!

Replies
8
Views
70
Replies
0
Views
135
Replies
12
Views
841
Replies
5
Views
122
Replies
6
Views
187

1,203,465
Messages
6,055,574
Members
444,799
Latest member
CraigCrowhurst

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back