Thread: Autosorting and averaging data

Hey All,
So I have two columns of data: Product SKU numbers (column A), and Machine Set Points (column B).
Lets say I have 2000 points of data collected over 2 months time and out of that are 20 unique SKUs. Each of these unique SKUs have a corresponding machine set points.
What I want to do is this;
1) Excel goes through column A and finds a unique SKU and puts that SKU number in column C. Then it loops to the next unique and so on...
2) if that SKU occurs 5 times, I want it to take the corresponding data in column B (machine set points), average all that data, and then place that output into column D next corresponding to column C (unique SKUs).
How can I program this in Excel?
Thanks alot folks

**EDIT**
I do know about advanced filtering, but the data is loaded in from another database. And as soon that data is refreshed, I want it to automatically analyze and autofilter it (rather than the end user having to advanced filter it).