View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
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