Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate name counts
I have a learning list for 12,000+ employees and I need to determine the
average number of courses per employee / per department. Is there a formula we can use? Employee Department Head Course John Doe Steve Buck Learning 101 John Doe Steve Buck Learning 102 John Doe Steve Buck Learning 103 John Doe Steve Buck Learning 104 Robert Smith Steve Buck Learning 501 Charlene R. Matt Mick Learning 101 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate name counts
Use a Pivot Table
-- Gary''s Student - gsnu200820 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate name counts
Excel 2007
Pivot Table with helper column Not easy: http://www.mediafire.com/file/jyyvqn...12_12_08a.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
counts | Excel Discussion (Misc queries) | |||
Counts | Excel Discussion (Misc queries) | |||
counts of dates | New Users to Excel | |||
getting several hundred n-counts | Excel Discussion (Misc queries) |