Returning an array of values

[flapjackcarl]

I'll explain this as best as I can.
I have a column in an excel. The column either displays a 0 or a nonzero number. I want to write a function in excel that will search this column, discard every 0, and return all values that aren't 0. Anyone know how I could do this?

[NBVC]

Say your range is A1:A100, try:

=IFERROR(INDEX($A$1:$A$100,SMALL(IF($A$1:$A$100<>0,ROW($A$1:$A$1)-ROW($A$1)+1),ROWS($A$1:$A1))),"")

adjust the $A$1:$A$100 range to suit and then confirm the formula with CTRL+SHIFT+ENTER not just ENTER and copy down as far as you need.

[flapjackcarl]

Thanks. That worked wonders!