View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Countdiff with more criteria

On Sat, 12 Dec 2009 14:27:51 +0100, "JP Ronse" wrote:

A pivot table is not an option in this project as the figures are for the
management only, the employees are allowed to consult their own figures but
not the ones of their colleagues.


You could present a filtered pivot table to the employees, showing only their
own information. And also present an unfiltered table to management.
--ron