Notifications
Clear all
Topic starter
Dear Sir,
I have an excel formula copied from your website but it's not working in my own worksheet.
Formula source: https://www.myonlinetraininghub.com/excel-remove-blank-cells-from-a-range (modified, attached).
Please help.
Thanks.
Posted : 30/07/2018 4:30 am
When there is a formula that returns zero length strings, those are not seen as blanks, but you can evaluate instead the length of the text in that cell:
=IFERROR(INDEX($A$2:$A$9, SMALL(IF(LEN($A$2:$A$9)=0,"", ROW($A$2:$A$9)-MIN(ROW($A$2:$A$9))+1), ROW(A1))),"")
Posted : 31/07/2018 6:17 pm
Topic starter
Thanks to Catalin Bombea. I got my problem solved.
Posted : 31/07/2018 6:20 pm
