Thread: Counting unique values with criteria
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Counting unique values with criteria
Excel 2007 PivotTable
Modernized formula for source data:
=1/COUNTIFS([Client],[Client],[Empl],[Empl])
Also shown: No formula method:
http://www.mediafire.com/file/2itm5en1hmx/12_31_09.xlsx
Reply With QuoteReply With Quote