How can I by formula extract numbers from column without the - Microsoft Community

example:

what have                         need

       a                                       b

1     50                                     50

2     60                                     60

3     0                                       40

4     40                                     30

5     0

6     0

7     30

thanks

use below formula , drag down - =iferror(index($a$1:$a$1000,aggregate(15,6,(row($a$1:$a$1000)-row($a$1)+1)/($a$1:$a$1000<>0),row(1:1))),"")

Office / Excel / Windows 8 / Office 2013