Excel 2007 : Finding the latest data based on 2 variables

[Dr Martin]

I suspect someone has already asked this question. If so can someone point me to the thread.

If not here goes.

I am trying to construct a table which will display the next validation date of a person/piece of eqpt based on the last test results.

The worksheet attached explains best. The test in B defines the date in E and I want to display the results in E against A and B. Obviously there can be more than one combination of A and B as more retests are added. Almost like a pivot table but with the the results displayed as the latest test date.