Hi all,

Having trouble figuring out how to put together this macro. Essentially, I have three columns (and, predictably, about 20,000 rows, so I don't want to do this by hand). The first two columns each contain a word, and the third contains a numeric value, and it looks something like this:

              A            B           C
          alligator       arch        0
          alligator       arch        20
          alligator       arch        17
          alligator       bottle      0
          alligator       camel       56
          alligator       camel       74
The A column isn't really important at this point. What I need is a macro that looks through column B, and average all the numbers in column C for each unique value of B. That is, 0 20 and 17 will all be averaged for arch. Bottle will be the average of just that one value, and so on. The problem is the highly variable numbers for every column B value. There are some that have 20-30 repetitions, and others only 1. I have had a hard time figuring out a way to do this. Any ideas?