Finding lowest values.

[Legacy 81319]

I have been working on trying to use the SMALL function to pick out the smallest values from a range of cells in a sheet.

=SMALL(A1:A15,1)
=SMALL(A1:A15,2)

Is what I have used but if I have say, 1,2,3,4,5,6,1 in the range i am choosing from the above function will bring up the results as 1 & 2. Is there any way I can pick out the 2 lowest values from the said range even if I have 2 values what are the same. The values could be anything ranging from 0-75 in some cases and I do have alot of times when I have the same value in more than one cell.

Any ideas guys?

 

[goldfish]

Welcome to the forums!

For me on the values 1,2,3,4,5,6,1, both

=SMALL(A1:A15,1) 
=SMALL(A1:A15,2)

Bring back 1. Not 1 & 2 like you got.

If I had to guess as why this was not true for you I would say be careful of what range your using especially if you are dragging the range. Make sure you write $A$1:$A$15 instead if you don't want the range to change when you drag the formula.

HTH,
~Gold Fish

 

[Legacy 81319]

Thanks thats worked a trreat.