Large Formula

[Mike]

Hello All,

Using Excel & Windows XP.

A B C
---------------------------------
1 17 6 14
2 31 22 28
3 6 48 11
4 24 21 4
5 19 33 30


When using the LARGE formula for data in cells A1:A5 =large(A1:A5,1)
returns a value of 31, the next largest =large(A1:A5,2) returns a value of
24. When I want to find the two largest in cells A1:A5 AND C1:C5 (value of
31 and 30) I receive an error above having too many arguments. It seems if
the cells are adjacent to each other the formula works but when the cells
are non-adjacent like in this case (A & C) the formula does not work.

Any help in this situation would be appreciated.

Michael

 

[Frank Kabel]

Hi
- first select A1:A5 and C1:C5
- define a name for this range ('Insert - Name - Define')
- use this new name as first parameter of your LARGE function

 

[Mike]

Thanks for your assistance, works fine.

Hi
- first select A1:A5 and C1:C5
- define a name for this range ('Insert - Name - Define')
- use this new name as first parameter of your LARGE function