Forum Discussion
Move Value between blanks and skip the blank cells
Hello, I've column that's include a values and blanks so i just need to move only values without taking the blanks with the formula what i tried is : used =IF(Main!O5,Main!J5,"") so the fo...
If it is simply a question of filtering out blanks from a list then, using 365, the following would work
= FILTER(list, list<>"")In legacy Excel it is distinctly more messy
= INDEX(list,SMALL(IF(LEN(list)>0,seq),seq))committed with CSE.
What do you mean by " list " ? should i apply the index with the first one ? which is true or false ? or apply it with the values table ?
'list' is a defined name that I have applied to whatever range of values from which you wish to remove the blanks. If the quantities are meaningful to you, then it would be reasonable to apply a more specific name.
[Having described A1 type references as an abomination that should never entered any computational environment anywhere (thus placing me at odds with virtually every spreadsheet user) I am not the right person to consult on the mysteries of the semi-anchored, directly-referenced range.]