+ Reply to Thread
Results 1 to 2 of 2

How to use row() in a CSE function

  1. #1
    Registered User
    Join Date
    12-29-2009
    Location
    Winona, MN
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to use row() in a CSE function

    The following CSE function gives a value error

    =TRANSPOSE(OFFSET(Data!$A$1,(ROW()-1)*9,0,9,1))

    but if I move the section (ROW()-1)*9 out to its own cell and then reference that cell in the CSE function

    =TRANSPOSE(OFFSET(Data!$A$1,K6,0,L2,1))

    it works fine.

    Is there a way to include the row argument in the CSE function?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to use row() in a CSE function

    You don't specify the cell in which the first formula appears - if we assume (using your example references) that it's say B6 on a sheet other than Data then

    Please Login or Register  to view this content.
    The above unlike the TRANSPOSE approach is not an Array and can be confirmed with ENTER as normal, also given avoidance of OFFSET it is also non-volatile.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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