Loop through a range of cells to create a column list of the non-blank ones.

[SueG]

Hi All,

I have a named ranges of cells - some are blank, some have text. I would like to loop through each cell in the range, and create just one column having the value of each non-blank cell (ignoring the blanks). Is there a way to do this with a formula?

Thank you!!

 

[Somendra Misra]

Hi,

See the attached file, hope this is what you required. The formula is the original work of @Sajan (If I am not wrong).

Regards,

 

[SueG]

Hi,

See the attached file, hope this is what you required. The formula is the original work of @Sajan (If I am not wrong).

Regards,