Smallest values excluding zero values

Hi guys,

I need you help. I am currently trying to get the 5 smallest values from a specific column. The problem is that the column contains positive values, one negative value and a lot of zero values. I tried the SMALL formula and excel returns the negative number and zeros.

I want to ignore zero values. Can you help me on that issue.
I highly appreciate it !

Thanks!

Best regars
TL

Hi

thanks for your fast reply.

I don't want to exclude minus figures. I just want to exclude zeros.

Let me give you an example. List of values: 1,3,5,-2,-6,-2,0,0,0.

Now I want to get the smallest five excluding zeros. That would be -6,-2,-2,1,3.

How can I do this?

Thanks
TL