Remove all Zeros from a column, no array, no VBA

[mescalante48]

Hello everyone,

please see below, can we remove all zeros from one column and take only the nonzeros values to a different column?

looking for a formula to do this, no arrays, please.

 

[mescalante48]

Have you really? Sum of values with irregular row intervals. for Sierra Charts

Thank you for renaming it, it won't happen again.
Just now I get how important it is to mention the Sofware we're using, I AM USING SIERRA CHARTS. I'll make it very clear from now on in all my posts.

Very grateful for your help.

 

[mescalante48]

Try

Book1
	B	C	D	E
1	223		3456
2	0		685
3	0		223
4	0		75
5	3456
6	0
7	0
8	685
9	0
10	0
11	75
12
13
Sheet1

Cell Formulas
Range	Formula
D1:D11	D1	=IF(LARGE($B$1:$B$11,ROW())=0,"",LARGE($B$1:$B$11,ROW()))

Thank you! your formula works, nevertheless we need the number in the order they are in the original column so, yours is not a valid solution yet.