Results 1 to 4 of 4

Find last row in range using INDEX

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-24-2006
    Location
    Los Angeles
    MS-Off Ver
    2019
    Posts
    328

    Find last row in range using INDEX

    Hi,

    How do I modify the following array formula to read a range that starts in cell C18 and extends down rows and across columns that are numbers referenced in two cells?

    Here's the formula now (which returns the last row containing any type of data in a specified range):

    ={(MAX((C$18:L28<>"")*ROW(C$18:L28)))-ROW(C$18:L28)+1}

    What I need is to have L28 replaced by INDEX (I think) that references cell A1 containing the last row number and cell A2 containing the last column number in the range to be searched.

    Thanks,

    Lawrence
    Last edited by skysurfer; 09-03-2010 at 02:09 PM.

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