I have a set of data that looks like this:

ID Value
12345_12_345 7
12345_12_345 10
12346_12_345 9
12346_12_345 10
12346_12_345 3
12347_12_345 3
12347_12_345 5
12347_13_345 10
12347_13_345 3
12347_13_346 8
12347_13_346 8

I need to create a macro that will march through the ID column and identify groups of similar data. Once a group is identified, i need to take the average of the value of that group, print it to a column adjacent to the values, and move to the next group.

Any thoughts?