Thread: Identifying the top five values in multiple groups
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Identifying the top five values in multiple groups
Excel 2007 PivotTable
Top, bottom 5
All ties will show.
No code, no formulas.
Animated.
http://c0718892.cdn.cloudfiles.racks.../04_27_10.xlsx
Pdf preview:
http://www.mediafire.com/file/w3jmmgm0jmj/04_27_10.pdf

Reply With QuoteReply With Quote