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

Hi Herbert, in my case the pivot table and the max filter doesn't seem to work. As the previous post, I have several entries for the same customer but I also have a status ID for each entry. I need to filter the most recent date by customer and obtain the status ID of that most recent date.
Example:
CompanyID Date Status ID
2540 19/10/12 1
2540 06/11/12 38
2539 19/10/12 1
2539 06/11/12 39
2538 19/10/12 1
2538 05/11/12 1
2538 13/11/12 37
2537 19/10/12 1
2537 06/11/12 23
2536 19/10/12 1
2536 06/11/12 22

The result I'm searching for is:
CompanyID Date Status ID
2540 06/11/12 38
2539 06/11/12 39
2538 13/11/12 37
2537 06/11/12 23
2536 06/11/12 22

I've attached a sample of my list.

Many thanks in advance