Posted to microsoft.public.excel.worksheet.functions
|
|
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
|