removing blank cells from a column

J

joeeng

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.
 
C

CLR

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
Click to expand...
arrow..........then just do Data > Filter > Autofilter to return to normal.

Vaya con Dios,
Chuck, CABGx3
 
Top