Reply to Message

assuming data is on sheet1 and you want dates in the right format, in your summary table enter the following as an array formula (ie with ctrl-shift-enter) in cell B4 and copy down

=TEXT(MAX(($A4=sheet1!$B$2:$B$13)*sheet1!$A$2:$A$13),"ddmmme")

this has the advantage that it doesn't need refreshing like a pivot table does to show the latest informtion