"Ken Wright" wrote:

Assuming your numbers are as follows, which numbers fall into your TWO
largest criteria

....A...B...C
1...9...1...1
2...4...5...
3...9...1...
4...4...6...
5...9...3...

Ken, for range A1-A4, the two largest numbers are 9 and 9 (at A1 and A3,
respectively, in this case). I can average those without a problem, but
next, I need to average the cells adjacent to A1 and A3, which are 1 and 1
in this case (at B1 and B3, respectively, in this case).

In other words, I need to find the two largest numbers in a range in
column A, and then average the cells in column B that are adjacent to the
two largest numbers in column A (B1 and B3 in my example).

Thanks much.

Joseph