OOPS, it does't ignore "0" sorry
I see you have a response to your problem.
Regards
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?