ctrl/shift/enter this:
=AVERAGE(SMALL(IF(A1:A2000=1,B1:B2000,""),ROW(1:3) ))
and/or
=AVERAGE(SMALL(IF(A1:A2000=2,B1:B2000,""),ROW(1:3) ))

"stuffandthings"
<stuffandthings.23a0zc_1140016804.8489@excelforu m-nospam.com wrote in
message news:stuffandthings.23a0zc_1140016804.8489@excelfo rum-nospam.com...

Here's the basic set up:

A| B
1| 456
1| 52
1| 78
1| 91
1| 12
1| 6
1| 7
2| 12
2| 80
2| 9
2| 15
2| 12
2| 6


And here's the question:
Basically, column A represents an item # and column B represent the
item price.

What I want to do is - and please know I'm sincere when I say I've
really been trying to solve this myself - every time A:A = 1, I want to
average the lowest 3 prices in B:B relating to A:A1... and then average
the lowest 3 prices in B:B relating to the A:A = 2.

Maybe I've completely over-thought this one.

Keep in mind, too... that this is a really basic example of what I'm
trying to do. There are over 1400 individual items, each being sold at
multiple prices. I understand enough of excel that a similarly basic
example will suffice - one that I can just create 1400+ times over.

Thanks to anyone ahead of time for your help.

Stuffandthings


--
stuffandthings
------------------------------------------------------------------------
stuffandthings's Profile:
http://www.excelforum.com/member.php...o&userid=31579
View this thread: http://www.excelforum.com/showthread...hreadid=512714