Results 1 to 3 of 3

Thread: Match Multiple Criteria & Find Oldest Date

  1. #1

    Match Multiple Criteria & Find Oldest Date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I am trying to return the oldest date within calls that match the SLA code and the region. I've used the formula listed below in the attached workbook, but it's not working. Can anyone please help me figure out a solution?

    Formula:
    =IF(AND($A$4:$A$7=Sheet2!$D$2:$D$497,$B$3="SLA4"),MIN(VLOOKUP(A5:A8,Sheet2!$D$455:$F$497,3,FALSE)),"")

    OPEN_CALL.xlsx

  2. #2
    Hello, I found an application similar to yours. See this page, http://exceltotal.com/buscar-un-valo...ados-en-excel/

    I think you can do this and is going to work in your case.
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

  3. #3
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    Excel Version
    Excel 2010

    Min(if

    Hi,

    an attempt: All formulas must be confirmed with control+shift+enter.

    Hope it helps
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •