Thread: Equivalant function for row() / column()

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

Try an xcelsius forum,

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