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.