Try something like the following:

=LARGE((A1:A5,A11:A15,A21:A25),2)

The test ranges are separated in the formula by commas, Excel's Union
operator, and together are enclosed in parens.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)






"Ian Elliott" wrote in message
...
Thanks for any help.
Is it possible to use the LARGE function in a non-continguous array? It
doesn't seem possible.
I got a couple arrays, all in the same column, but with rows in between
them.
Thanks again.