Filter Lines of Text File based on Value AND Date

[mikeg71]

Hello... I am need of some help on this. I cannot figure out how to filter a file where I want to extract the last line of a persons badge number for a given day. I have attached a screenshot of what I am working with. Each hi-lighted lines are the ones that I need to extract from the file and the file can usually be fairly large. The only change in the file will be "passed" or "failed" for each badge number. I have not been successful searching for an example of what I want to do. I can split the file and get values, but that's as far as it goes. Thanks for any examples someone can help me with.