I have a column of numerical values and random empty or null value
cells. I want to compress the column so I only retain the numerical
values without losing their sequence. Ideally if there was a function
like "delete row" where you check for null value cells and delete the
appropriate row. Macros won't work because the column sequence changes
whenever worksheet is activated

Thank you


--
Harrymo
------------------------------------------------------------------------
Harrymo's Profile: http://www.excelforum.com/member.php...o&userid=30620
View this thread: http://www.excelforum.com/showthread...hreadid=502746