Average range of cells in column if values in adjacent column are equal

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:

Please Login or Register  to view this content.

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?

First sort by column B, then use the SubTotal functionality of Excel and select from the dropdown box that at each change in Column B use the function average and add subtotal to column C checking the Summary below data check box. See File attached

Wow, thank you! I have been using Excel for years and I never knew it had that function. Think of all the hours that could have been saved, heh. Anyway, thanks a lot!

You are welcome.
Don't forget to click on the Star below the posting to show your appreciation for the help received and mark the posting as solved.

I'm looking for a function similar, but I can't add a subtotal row. I need to do it as a column. For example,if I have in column A 2063.....2065..2083....so on, and i want to average the hours for each product listed but just limit it to the individual product, is there an match average function i can use? Or index average?