But note the additional numbers I added and clarify what the result would
be, or, clarify that it is not possible to have more than two cells equal
the TOP TWO numbers, eg

what if you had 1,9,2,8,8 - which are the top two?

At the moment your question lacks clarity wrt possible outcomes, so we need
to nail down what is and isn't possible with your data. This will affect
any answers you are given.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Joseph Spain" wrote in message
news:9SyLd.108032$Wo.65054@lakeread08...
"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