View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default finding 10 smallest numbers from last 20 input

Excel 2007 PivotTable
Find 10 lowest amounts in last 20 days.
Ignores zero amounts.
No formulas used.
With macro option.
Dynamic and animated.
http://c0718892.cdn.cloudfiles.racks.../05_02_10.xlsm
Pdf preview:
http://www.mediafire.com/file/gwmdid5jwnh/05_02_10.pdf