Thread: Enhance sumproduct to return unique employee code count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Enhance sumproduct to return unique employee code count
Bob, thanks.

I adapted your suggestion to suit:

=COUNT(1/IF((Month_of_Occurence=$B$2)*(Month_of_Occurence< =$B$3)*(Branch=$B10),MATCH(EmpCode,EmpCode,0)=ROW( EmpCode)-MIN(ROW(EmpCode))+1))

and tested it out. Some results were okay but some were out (lower than
actuals). I'm not sure if I had adapted it correctly above?

Ron's suggestion returned correct results.


Reply With QuoteReply With Quote