Results 1 to 4 of 4

Equivalant function for row() / column()

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2010
    Location
    bangalore, india
    MS-Off Ver
    Excel 2007
    Posts
    16

    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
    Attached Files Attached Files
    Last edited by shruthitulsi; 12-11-2010 at 04:22 AM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1