How can I show the latest date that has the corresponding value in another column in excel?

I have an Excel spreadsheet with dates in one column, and the results / values ​​in another column (not next to each other, but on the same sheet). I want to create a small pivot table in which the last date will be displayed with the corresponding result in the results column, since the last date does not always give results immediately. I would appreciate any help with this.