thank you.
"Frank Kabel" wrote:
Hi
try:
=IF(ISERROR(INDEX('sheet1'!$C$1:$C$20,SMALL(IF('sh eet1'!$C$1:$C$20<"",
ROW('sheet1'!$C$1:$C$20)),ROW(1:1)))),"",INDEX('sh eet1'!$C$1:$C$20,SMAL
L(IF('sheet1'!$C$1:$C$20<"",ROW('sheet1'!$C$1:$C$ 20))
--
Regards
Frank Kabel
Frankfurt, Germany
"Shooter" schrieb im Newsbeitrag
...
Frank,
If I put this formula in worksheet 2 , cell B2, how should I modify
the
formula to do the same thing as we did in cell e1 of worksheet 1?
Thanks.
"Frank Kabel" wrote:
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
|