jb
Member
I have an excel sheet test_blank which contains list from b5 to b15 with empty cells in between. These empty cells have "" values.
I have an array formula in c5 to c15 which is written to generate a list without blank cells.
Means c5 has value aa, c6 has bb, c7 must have cc, c8 must have dd and so on.
My formula is not working in c5 to c15. I have tried to apply istext with len function. But it does not work.
I checked formula with list of values where empty cells does not have "". It works. I have shown data in e5 to e15 and formula in f5 to f15.
I have attached sample sheet. My original sheet will contain a list of values where empty cell will contain either text or "".
I have an array formula in c5 to c15 which is written to generate a list without blank cells.
Means c5 has value aa, c6 has bb, c7 must have cc, c8 must have dd and so on.
My formula is not working in c5 to c15. I have tried to apply istext with len function. But it does not work.
I checked formula with list of values where empty cells does not have "". It works. I have shown data in e5 to e15 and formula in f5 to f15.
I have attached sample sheet. My original sheet will contain a list of values where empty cell will contain either text or "".
Attachments

8.4 KB Views: 9