Greetings, all. I'm new to the forum and have a specific question that is driving me nuts. I would like to sort a spreadsheet by column A, then apply a drag and drop formula that will return the average value of the data in column B for each grouping is column A.

Put differently, take the example below. I want Excel to tell me the average value of the data in column B for the total occurances of 34 in column A, or 10.67. I am working on spreadsheets with 15,000+ columns, comprised of 7,000 - 8,000 uniuque values in column A (some only occur once, some 3+x).

Any help would be appreciated!!!!

Chuck

A B C?
34 $10
34 $15
34 $7
18 $44
18 $22
16 $9
16 $84
16 $44