Eliminating Blank Values
In B1 enter:
=IF(ROWS($1:1)<=COUNTA($A$1:$A$100),INDEX($A$1:$A$ 100,SMALL(IF($A$1:$A$100<"",ROW($A$1:$A$100)-MIN(ROW($A$1:$A$100))+1),ROWS($1:1))),"")
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
Then copy B1 and paste down as far you you need.
--
Gary''s Student - gsnu200812
"Ken" wrote:
I have a list in Column A of 100 values, from cell A1 to A10. Several of the
cells are empty (=" "). How can I arrange Column B so that it includes in the
same order all the values of Column A, but excluding the empty cells?
--
Ken
|