Large Formula

[Mike]

Hello All,

Using Excel XP

When using the large formula =LARGE(A1:A10,1) the formula works fine.
When I try to use the formula in non-adjacent cells =LARGE(A1:A10,B1:B10,1)
I receive an error message that I've entered too many arguments. Any
suggestions how I can get the formula to work in non-adjacent cells would be
appricated.

Thanks in advance,

Michael

 

[Frank Kabel]

Hi
one way
try defining a name for your non contingenous range and use this name
in your formula

 

[Ragdyer]

Since you *are* looking for the *largest* in your example, how about:

=MAX(A1:A10,J1:J10,X1:X10)

 

[Chip Pearson]

Mike,

Try

=LARGE((A1:A10,B1:B10),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mike]

Thanks for everyone's help, works fine.

Mike,

Try

=LARGE((A1:A10,B1:B10),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[CLR]

Non-adjacent cells?...........

=LARGE(A1:B10,1) seems to work

Vaya con Dios,
Chuck, CABGx3