Formula to identify numbers in a column and return another number on a cell on the same row

[Matenjagwo]

Excel gurus,

I need help - i have a table that has numbers and some cells are blanks. I need help with a formula that will only identify the numbers, and return a value on another cell on the same row and list these downwards.

Thanks

 

[arthurbr]

With O365 you can use the FILTER function ( your profile is incomplete)

 

[Radoslaw Poprawski]

provide minisheetso wewill know what we are working on