I am trying to create a macro which will quickly auto filter and produce a “Bottom 10” list

Problem is that my list has lots of zeroes which I want the filter to ignore.

However if I change the zeros to blank the “Top 10” autofilter function doesn’t work (think it needs a number within each cell)

Is there any way around this?

Thanks in advance