+ Reply to Thread
Results 1 to 2 of 2

Trouble with array formula if statement recognizing text

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    8

    Trouble with array formula if statement recognizing text

    Having some trouble with a formula. I want to return the nth smallest matching row which fits two criteria. Here is my current formula:

    =INDEX(HR_potential_participants_DB[Name], SMALL(IF((HR_potential_participants_DB[Training session]=$B$1)*(HR_potential_participants_DB[Met minimum 360 threshhold?]="No")=1, ROW(HR_potential_participants_DB[Training session])-ROW(HR_potential_participants_DB[[#Headers],[Training session]]), 10000), n), 1)

    I know that the section of the formula dealing with the hard cell reference [Training session]=$B$1 works because when I pull out the second condition it functions correctly. The second half of the if statement doesn't work even on it's own, so I know it's the issue. Any ideas? (I know for a fact that many pieces of my table fit these two conditions).

    Thanks!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Trouble with array formula if statement recognizing text

    If possible please attach a sample workbook.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

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