Hi Max,

thanks - the formula is just what i needed. However for=20
some reason I can't get the array to work when i copy it=20
into the actual worksheet that i'm using. I've changed the=20
formula cell's from B1:B100 to where I need it to search=20
(column I51:I57) and array-enter - however it just stays=20
blank?! i'm stumped - do you know why this might be?=20
Thanks!=20


-----Original Message-----
You've got 2 responses to your identical post=20
in .public.excel

--=20
Rgds
Max
xl 97
--
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
---
"Wesley" wrote in=20
message
...
I have one column with a formula in multiple rows=20
within the same column.
The formula pulls data from other parts of the=20
spreadsheet or leaves the
cells blank. An example of the formula is =3Dif
(A1=3D0,"",A1).

The outcome is to have a column with data in multiple=20
rows mixed with
blank
cells like so.

Bob
Mary
"Blank"
Joe
"Blank"
Jill

What I would like to do is pull the data automatically=20
from this column
putting the data in another column excluding=20
the "Blank" cells like so:

Bob
Mary
Joe
Jill

Any help would be most appreciated.

Thank you,

Wesley



.