Help with Formula: most recent offer

Summary

I need help creating a formula to pull in the most recent offer

Content

I'm pulling together a list of YTD offers.  I am finding records where the candidate has accepted the offer then declined a few days later.  I would like to the report to only show the most current offer.  I can not use the "Current Step Name" as some of the candidates have moved to "Hire". 

In the example below, I only want to see the Candidate Declined record

Any help would be greatly appreciated.  Thanks in advance.

 

Current Status

Req. Identifier

Submission Identifier

Historical Step Name