Skip Blank Cells While Copying A List
Hi,
Can someone please help me out with an excel formula . The solution i want is like this
The source column can have any entries with blanks in between :
apple
orange
12334
mango
5678
zcech
I need to copy this data to new column skipping blanks:
apple
orange
12334
mango
5678
zcech
I need a fomula (not macros please) and it shouldnot use row()
The formula i have tried is
if source data is in column A
write in column C
=IF(TRIM(A2)="","",ROW())
and write in column B
=IF(ISERROR(SMALL(C:C,ROWS($A$2:A2))),"",INDEX(A:A ,MATCH(SMALL(C:C,ROWS($A$2:A2)),C:C,0)))
Select both B and C and dropdown till the no f rows u want.
This formula works very well.
But the application i use (Xcelsius) doesnot support row( ) , rows( ). so i am in search of another formula.
Kindly Help ........................ Pleache
Thanks in Advance,
Shruthi
|