S SueG New Member Jan 25, 2015 #1 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!!
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 Excel Ninja Jan 25, 2015 #2 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, Attachments SueG_Chandoo.xlsx SueG_Chandoo.xlsx 10.7 KB · Views: 15
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,
S SueG New Member Jan 26, 2015 #3 Somendra Misra said: 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, Click to expand...
Somendra Misra said: 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, Click to expand...
