You can also use the autofilter to filter the nonblank cells, copy and paste
to a new sheet or new range.
No formula needed.


"cent" wrote:

I need a formula to
1) look in colunm a, gather any numbers present in that colunm, even though
most wil be empty
2) then i want them to take that list, get rid of the empty cells and put
that data either into a new table or on another sheet.
thanks.