+ Reply to Thread
Results 1 to 1 of 1

Index First Three Results That Match Criteria In Google Sheets

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Question Index First Three Results That Match Criteria In Google Sheets

    Hi again,

    I was able to come up with a formula that works great for listing single matches that fall within dates. Any more than one match, and CONFLICT is shown, which was my initial intention. I have this formula pasted in each cell in a row on a calendar-type sheet, where each column is another workday - this one is for BILL, using named ranges:

    =IF(SUMPRODUCT(--(WORKDAY("Jan 1, 2019",COLUMN()-2)>=BILLSTART),--(WORKDAY("Jan 1, 2019",COLUMN()-2)<=BILLEND),--(BILLEND<>""))=1,INDEX(BILLJOB,SUMPRODUCT(--(WORKDAY("Jan 1, 2019",COLUMN()-2)>=BILLSTART),--(WORKDAY("Jan 1, 2019",COLUMN()-2)<=BILLEND),--(BILLEND<>""),ROW(Info!$A$1:$A$47))),IF(SUMPRODUCT(--(WORKDAY("Jan 1, 2019",COLUMN()-2)>=BILLSTART),--(WORKDAY("Jan 1, 2019",COLUMN()-2)<=BILLEND),--(BILLEND<>""))>1,"CONFLICT",""))

    Now, I need to show up to the first 3 matches, and display CONFLICT if there are more matches than this, but I can't quite figure out how to do this. Any suggestions? See this example Google Sheet for more details.

    Edit: Marked as SOLVED due to attempting a simpler approach to this issue.
    Last edited by swordswinger710; 03-28-2019 at 08:31 AM.
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index/Match Help - Google Sheets
    By JenMasters84 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-25-2018, 02:52 PM
  2. [SOLVED] Sum Index/Match results across multiple sheets
    By wiggy_worm in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-12-2016, 01:40 AM
  3. [SOLVED] Index match on multiple criteria/ results
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2015, 10:40 AM
  4. Replies: 0
    Last Post: 12-03-2014, 05:10 PM
  5. Index / Match with 2 Criteria showing all results
    By corhrtz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2014, 05:56 PM
  6. [SOLVED] How to index and match multiple criteria without repeating results?
    By PistachioPedro in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-20-2013, 05:38 PM
  7. Replies: 0
    Last Post: 03-02-2012, 11:16 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