duplicate name counts

[Kimmie]

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

 

[Gary''s Student]

Use a Pivot Table

 

[Herbert Seidenberg]

Excel 2007
Pivot Table with helper column
Not easy:
http://www.mediafire.com/file/jyyvqnwz1hg/12_12_08a.xlsx