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 Using (SUM(IF(FREQUENCY....to determine unique values

Excel 2007 PivotTable
No formulas needed.
Three ways.
http://www.mediafire.com/file/yz2jbe...11_05_09b.xlsx