From: Herbert Seidenberg on
Excel 2007 PivotTable
Consolidate and filter by most recent date.
No formulas needed.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_30_10.xlsx
Pdf preview:
http://www.mediafire.com/file/yo4dqi5cnzj/04_30_10.pdf