Hey there guys.

I was hoping someone could help me with this. I would like to average a column based upon another column value. Namely, if one column is a duplicate, I would like to take the column to its right value and average all the duplicates. For example

comp 1409 99.7
comp 1409 99.5
comp 1409 100
comp 1308 65.7
comp 1509 99.5

I would like that to become

comp 1409 99.73
comp 1308 65.7
comp 1509 99.5


Any help is appreciated. Thanks much!