return numbers

[yuventus16]

hey,
I have a column that has zeros from top to bottom(T5: T100). It gets filled up every day by me with different numbers, some positive & some negative.
I have a different column that I want to fill with all the numbers that are different than 0(AB30: AB60).

for example(T5: T100) is:
day 1 - 20
day 2 - 0 (no change)
day 3 - (-15)
day 4 - 3
day 5 - 0 (no change)
day 6 - 10
the rest of the days are zeros as well...
all the way to day 100.

In my other column(AB30: AB60) I would like to have:
20
-15
3
10

All the zeros are there and cannot be removed.
I am not able to figure this up.
thank you to all the helpers!

 

[Eric W]

Welcome to the forum.

Put this in AB30, confirm with Control+Shift+Enter, then drag it down:

=IFERROR(INDEX($T$5:$T$100,SMALL(IF($T$5:$T$100<>0,ROW($T$5:$T$100)-ROW($T$5)+1),ROWS($AB$30:$AB30))),"")

 

[yuventus16]

Eric,
thank you very much it works perfectly!

 

[Eric W]

You're welcome!