"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, please disregard my previous message. I failed to realize you added
a 5th row to my example. I understand what you were asking now. I would
prefer to have a solution for averaging only the two cells that correspond
to the "two 9s" that Excel picks for the largest two numbers.

But for grins, and if you wouldn't mind showing me, how you could find the
average of B1, B3, and B5 for a case like yours above, and based on the
largest two values in column A?

Best regards,
Joseph