Results 1 to 9 of 9

Modify an IFERROR INDEX array function to LINK a cell to ROW reference

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Private
    MS-Off Ver
    Excel 2010
    Posts
    45

    Modify an IFERROR INDEX array function to LINK a cell to ROW reference

    Good Day

    We'd like to modify a function to improve efficiency of the workbook attached

    Modify array function in B for ROW link such that the Vlookup in D & E is not necessary & therefore can delete columns A & B

    current IFERROR(INDEX($I$1:$I$11161,LARGE(IF($H$1:$H$11161>=LARGE($H$1:$H$11161,1),ROW($H$1:$H$11161),""),ROW(A1))),"")
    wanted IFERROR(INDEX($I$1:$I$11161,LARGE(IF($H$1:$H$11161>=LARGE($H$1:$H$11161,LINK(F4)),ROW($H$1:$H$11161),""),ROW(Value or calculation from cells F1-F4)))),"")

    Current solution: Vlookup F in column A & report D & E
    Column E= end
    D = start
    C = difference between start & finish

    Thanks very much for your help, all comments appreciated

    Paul
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Iferror, index, array...
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 07:56 PM
  2. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  3. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  4. Now With Index -- IF Function Does Not Work With Cell Reference
    By Gary in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2006, 09:20 PM
  5. [SOLVED] Cell reference from previous index function
    By xadnora in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2005, 05:06 PM

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