Excel Macro that merges duplicates and adds two calculations

[jodo2]

Hello all,

I am looking to create a macro that does the following:

The script has to find the "average days unscheduled" from items with similar name.

For example, Finance appears twice, one with days unscheduled 20 and another 2. So the average days unscheduled is 11.
Finance2 appears only once so average # of days unscheduled is 5 and so on.

So one step is to calculate the average # of days unscheduled for the values that have the same name
and another step is to find the count of the values of the same name, and remove/hide the duplicates.

Doing it manually, I know can do do a countif to get the # of times the value is repeated, and then highlight Days unscheduled for the same name and look at the average, I'd like to know to have a macro do the same thing quicker.

Thanks in advance for any help you guys can provide!!