Results 1 to 3 of 3

Index, Match, Small with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2017
    Location
    Philaldephia
    MS-Off Ver
    2010
    Posts
    8

    Index, Match, Small with multiple criteria

    Hi everyone,
    I need help with finding a combined function to list all the names that fit the criterias below:

    Data:

    Column A Column B Column C
    Name Level Days
    A P 1313
    B H 144
    C M 60
    D P 773
    E P 90
    F P 60


    Need to find all the names in Column A that fit both criterias: Level in column B is "P" and Days in Column C is larger than 145.
    Attached Files Attached Files
    Last edited by anhlu; 04-04-2017 at 03:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with Index Small Formula with Multiple Criteria
    By mang0Master in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-09-2017, 12:09 PM
  2. Array Index Small with Multiple and OR Criteria
    By MichaelDoughertyJr in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2016, 05:09 PM
  3. Index/Match, Multiple Critiera with MIN (or SMALL)
    By lookingforhelp1 in forum Excel General
    Replies: 8
    Last Post: 11-04-2015, 06:38 PM
  4. Index / Match / Small by Month with Date Criteria
    By marcusduton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2015, 05:37 AM
  5. Replies: 9
    Last Post: 08-29-2014, 09:42 PM
  6. [SOLVED] INDEX MATCH SMALL ROW, Double criteria Lookup
    By GP_SRT in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-22-2013, 11:15 AM

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