selection of cells within column while keepning same order

F

Frans

Hi, i would be glad if someone could help me out with this (easy?
problem;

Column A contains N values. From these values i want to select certai
(let's say > 0), and have them in column B, but with the same order.

So; 8 0 0 7 3 0 4tc.

must become;

8 7 3 4 etc.

Anyone?
Thanks in advance
 
F

Frank Kabel

Hi
one way: enter the following array formula in B1 (entered with
CTRL+SHIFT+ENTER):
=INDEX($A$1:$A$100,SMALL(IF($A$1:$A$100>0,ROW($A$1:$A$00)),ROW(1:1)))
and copy down
 
Top