Need to update formula

[jma116]

Hi everyone,

I'm using Excel2013.

On my excel sheet, I'm trying to achieve 2 objectives: (1) to see when a client last submitted a work order, and (2) should not return the same date.

My current code is this:
{=IF(A3979="","-",INDEX($B$2:$B3978,MAX(($A3979=$A$2:$A3978)*MATCH(ROW($A$2:$A3978),ROW($A$2:$A3978)))))}

This achieves the first objective, but if the client sends more than 1 request on the same day, the subsequent requests return the same date. How can I fix this formula to achieve both objectives?

 

[jma116]

Update:

Found a solution involving Excel 365, but it uses a new formula not available in 2013 version.