| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enhance sumproduct to return unique employee code count
Looking for a way to enhance this sumproduct expression
to return a unique employee code count: =SUMPRODUCT((Month_of_Occurence=$B$2)*(Month_of_O ccurence<=$B$3)*(Branch=$B10)) Suppose the expression above returns: 5 In a corresponding named range: EmpCode (range not used in the expression as yet) the 5 instances returned are due to eg: Emp1 Emp2 Emp1 Emp3 Emp2 Would like to return a unique employee code count of: 3 for the 5 instances. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Enhance Sort Results | Excel Discussion (Misc queries) | |||
| Return employee name when the employee's number is entered | Excel Worksheet Functions | |||
Threaded Mode
