Thread: Finding most recent date for each customer - XL 2007
View Single Post
  #3  
Old April 30th, 2010, 04:42 PM posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
external usenet poster
  
Posts: 1,113
Default Finding most recent date for each customer - XL 2007
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