Equivalant function for row() / column()

[shruthitulsi]

Hi,
I am working on Xcelsius which is based on MS Excel.
Xcelsius doesnot support row() and column().
I have few fomulas
1) Skip Blank Cells Dynamically

=IF(ISERROR(SMALL(C:C,ROWS($A$2:A2))),"",INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$2:A2)),C:C,0)))

in column C
=IF(TRIM(A2)="","",ROW())


2)Arrange Cells Dynamically

=IF(ISERROR(MATCH($A16,$A$2:$A$11,0)),"",INDEX($A$2:$H$11,MATCH($A16,$A$2:$A$11,0),COLUMN()))




Can i have some function equivalant to row() or column() which i can replace it with.



Thanks & Regards,
Shruthi

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

5678

zcech


I need to copy this data to new column skipping blanks:

apple
orange
12334
5678
zcech


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




Thanks In Advance,
Shruthi

[Marcol]

You might be able to work with the alternatives I offered here

http://www.excelforum.com/excel-new-...namically.html

You have only had that last formula for about half an hour, give me a break!!!!

[davesexcel]

Try an xcelsius forum,

http://www.forumtopics.com/busobj/viewforum.php?f=99

[shruthitulsi]

@ Hi Marcol,

Thanks a lot , For ur valuable time, i could implement the formula in my application, that was great help for me . thanks a ton


@Dave

Thank you for the link, it will be of much help for me.



Thanks & Regards,
Shruthi