Results 1 to 3 of 3

Index Match: First "1" after x

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    311

    Index Match: First "1" after x

    I'm convinced there's a super easy solution to the following

    Basically, I'm trying to find the column location of the first "1" after the value stated in KP. (KR contains the correct results)

    i.e. The first "1" after 287. (193)

    The issue is that KP is variable, hence a conventional array doesn't work.

    Also, the formula is to be replicated thousands of times - & solutions such as this:

    Formula: copy to clipboard
    =IF($KT2=TRUE,IFERROR(AGGREGATE(14,6,$A$1:$KN$1/($A2:$KN2=1),COLUMNS(KU2:$KU2)),""),"")


    .. crashes Excel!
    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. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. IF(ISNA(INDEX,Match)"Yes", "No"
    By prince_xavier2001 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-22-2013, 11:36 AM
  4. Replies: 7
    Last Post: 04-11-2013, 12:46 AM
  5. Strings Variables in Range("A1").Formula = "=index/match" ?
    By nadnerb5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 05:07 PM
  6. [SOLVED] Variable "sheet-name" and "range-name" wanted in INDEX/MATCH-function
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2012, 04:09 PM
  7. Replies: 3
    Last Post: 02-16-2011, 02:55 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