• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index to Find Recent Date on Multiple Criteria

I've got a list of change orders for various sites which will result in multiple listings. What I need to extract on the summary is the most recent date of the accrual which is column N. I grabbed a formula from Microsoft's help page, but it errors out. I've put a test workbook on dropbox. I always appreciate the ninjas that come to my rescue.


https://www.dropbox.com/s/0jz6kcaj8f5l23n/example%20workbook.xlsx
 
The Doctor


In Sheet1, Select C2:C5

=INDEX(Sheet2!$N$2:$N$24,MAX(IF((Sheet2!$A$2:$A$24=$A2)*(Sheet2!$M$2:$M$24>0),ROW(Sheet2!$A$2:$A$24)))-1,1) Ctrl+Shift+Enter
 
Back
Top