Hi
put the following formula in E1 for example (entered as array formula
with CTRL+SHIFT+ENTER):

=IF(ISERROR(INDEX($C$1:$C$20,SMALL(IF($C$1:$C$20< "",ROW($C$1:$C$20)),R
OW(1:1)))),"",INDEX($C$1:$C$20,SMALL(IF($C$1:$C$20 <"",ROW($C$1:$C$20))
,ROW(1:1))))

and copy this formula down to D20

--
Regards
Frank Kabel
Frankfurt, Germany

"Shooter" schrieb im Newsbeitrag
...
My worksheet (w1) has values in cells A1:D20. All cells have a
formula or
link to another worksheet. Some of the cells are blank (but still
have a
formula in the cell). All of the cells change periodically as I
change the
values in other worksheets. In worksheet 2 (w2) A1:a20, I would like
to list
all of the values of w1 C1:c20 but without any blank rows. I would
like a
formula that will do this automatically. Thanks for your suggestions.
--
Shooter