Using Small to return 2nd smallest value
 

I need to extend the formula to exclude multiple values, empty cells & zero
values in the range. Can anyone help?

Using Small to return 2nd smallest value
 

Which formula is this?

Pete

On Feb 12, 1:34*pm, Rachel7 wrote:
I need to extend the formula to exclude multiple values, empty cells & zero
values in the range. *Can anyone help?

Using Small to return 2nd smallest value
 

Hi Pete,

It's 'SMALL', Bernard (on the other post, I didn't mean to post it so many
times) has given me a vba code, but I'll need to read up on vba before I can
use it.
Maybe I need to resolve the answer using multiple stages of formulae???

"Pete_UK" wrote:

Which formula is this?

Pete

On Feb 12, 1:34 pm, Rachel7 wrote:
I need to extend the formula to exclude multiple values, empty cells & zero
values in the range. Can anyone help?