Wondering if anyone has ideas to get this done...
Col A Col B
Cat 100
Cat 225
Cat 175
Cat 179
Cat 180
Cat 125

Now, I want to use a formula to give me the average of the top 3rd group,
average of the middle 3rd, and average of the bottom 3rd (top 3rd here would
be the 180 & 225, mid 3rd would be 175 & 179, bottom 3rd would be 100 & 125.
It has to also look at the "Cat" label. So, average top 3rd when = cat, etc.

Let me know of any questions....thanks in advance!