Another option is to create a PivotTable to summarize the data. Add
Employee Name and ID to the row area, and hours to the data area.
Double-click the Hours button, and choose to Summarize by Average.

After the PivotTable is created, you could copy it, and paste in another
location as Values.

Eva Shanley wrote:
I have a 25,000 row spreadsheet that consists of employee
data for a 6-month period, which means the employee
information repeats for many weeks. I need to average
hours per employee which is easy enough using auto
subtotals. However, the user wants the employee
information (such as employee number, etc.) repeated in
the summary record, which it does not, and I then need to
delete all the rows that do not have the average summary
in them. What is the easiest way to do this? I've thought
of several things, but I'm sure I'm looping this code
around more times than I need to. Any help will be
great! Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html