Prev: Saving as webpage, uploading via FTP
Next: General number formats changing to Dates or Euros
From: Nicawette on 29 Jan 2010 19:25
Hi

is it possible to have the bottom ten item of a pivot table but
excluding specific value(s)

eg I have a pivot table with the bottom 10 of cost

item 1 -200 $
item 2 -300$
item 3 -0$
....

I would like to exclude item that have a cost = 0$ and have only
items greater than 0.

thanks
From: Herbert Seidenberg on 30 Jan 2010 19:48
Excel 2007 PivotTable
Bottom 10, no zeros.
Three ways.
http://www.mediafire.com/file/kd3dydo3ww4/01_31_10.xlsx
From: Nicawette on 5 Feb 2010 08:42
thank you for the spreadsheet.
 | 
Pages: 1
Prev: Saving as webpage, uploading via FTP
Next: General number formats changing to Dates or Euros