Using Array in a row to retrieve specified field

Okay, I have an issue and I think it could be resolved by a formula. If not, please let me know so I can move it to VBA area.

Anyways, here's my issue. I have a row of data (Code, Description, Date) that just repeats with different values. Some stops earlier than others. What I'm trying to accomplish is to retrieve a certain code and the date on a new column at the end. Here's the catch, certain codes repeat but I want the code that has the latest date.

There are 100 different Codes but I'm only interested in 20 of them. To make it easier I've highlighted them. They will always be arranged that oldest date is on the left and it increases to the right. If there isn't a value that I'm interested, I'd like to leave it blank. It'll make much more sense once you see the file. It's just very hard to explain it with words. Thank you.

Must your data be in that format? If the data is repeating and is of the same type, can we use just three columns? This would be easier for calculating values.

I could not get the answer you needed with the data in the format you provided so I changed the format, but kept the integrity of the data. I also added a pivotTable to show you that you didn't need to use a function. If this doesn't work I apologize and back to the drawing board.

Excel Row Array Example.xlsx