+ Reply to Thread
Results 1 to 2 of 2

Using Small within Index and Match will only give me the 1st occurrence

  1. 05-11-2023, 01:40 PM #1
    edsan21
    edsan21 is offline
    Registered User
    Join Date
    06-09-2009
    Location
    Brownsville, TX
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Using Small within Index and Match will only give me the 1st occurrence

    As you can see, I have only changed the occurrence from 1 to 2 and I get an #N/A.


    Excel Formula Help.png

    Excel Formula Help.xlsx
    Reply With QuoteRegister To Reply
  2. 05-11-2023, 02:39 PM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Using Small within Index and Match will only give me the 1st occurrence

    Try this:

    =INDEX(E:E,AGGREGATE(15,6,ROW(E$2:E$9)/((A$2:A$9>=H$10)*(A$2:A$9<=I$10)*(D$2:D$9=G$10)),1))
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Most frequent occurrence from Index and not Match
    By Danielnirr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2022, 09:46 AM
  2. [SOLVED] Index Match only after Occurrence of specific text
    By Dendrinos2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2022, 03:38 AM
  3. INDEX/MATCH single occurrence
    By donjamin in forum Excel General
    Replies: 1
    Last Post: 10-27-2021, 08:52 AM
  4. INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single cell
    By Success4me in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-19-2019, 08:00 AM
  5. [SOLVED] Combining INDEX/MATCH with several criteria and INDEX/SMALL
    By Dresas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-15-2018, 11:02 AM
  6. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. [SOLVED] Index Match row value and nth occurrence of header
    By dm@stams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2013, 05:43 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1