Did you try this : =SMALL(A1:A100,2) this formula ignores text, blank cells and
"0"
HTH
John
"Rachel7" wrote in message
...
I need to return the 2nd smallest number in a range of cells, but the range
contains empty cells, multiple values & zero values. I need to ignore the
empty cells, multiple values & zero values - can this be done?