removing blank cells from a column

Is there a combination of functions that can create a new column without
blank cells from a column with blank cells? I want this to be accomplished
in real-time so that if cells are changed in the column with blanks, the
other coolumn's cells change automatically.

Depending on what you are wanting to do with the column with no blanks, your
original column can be viewed that way by selecting the data, then doing Data
> Filter > Autofilter > and selecting "Non-blanks" from the
arrow..........then just do Data > Filter > Autofilter to return to normal.

Vaya con Dios,
Chuck, CABGx3



"joeeng" wrote:

> Is there a combination of functions that can create a new column without
> blank cells from a column with blank cells? I want this to be accomplished
> in real-time so that if cells are changed in the column with blanks, the
> other coolumn's cells change automatically.