View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default calculate percent between 10.0 and 12.0 for data in multiplesheet

Excel 2007 PivotTable
Consolidate, Value Filter.
Real numbers only.
With macro.
http://c0444202.cdn.cloudfiles.racks...01_20_10a.xlsm