Compress column
 

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=502747

Compress column
 

You have an active thread in .misc.

Harrymo wrote:

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=502747

--

Dave Peterson