Large with multiple n's

[AT--o]

Hi guys, Im trying to show the three largest numbers.

=Large((A1:C1,F1:H1),(1,2,3))

The following works but a want it the simplest possible

=Concatenate(Large((A1:C1,F1:H1),1),Large((A1:C1,F1:H1),2),Large((A1:C1,F1:H1),3)

Thanks

 

[MrKowz]

Try:

=Large((A1:C1,F1:H1),1)&Large((A1:C1,F1:H1),2)&Large((A1:C1,F1:H1),3)

However, you might want to put a delimiter in there:

=Large((A1:C1,F1:H1),1)&", "&Large((A1:C1,F1:H1),2)&", "&Large((A1:C1,F1:H1),3)

 

[AT--o]

Hi, Im not looking for different ways to concatenate I just want to know is if the Large function can have multiples n´s.

Thank you.

 

[ukmikeb]

Hi

Or alternatively -

Select the cells A1 through C1 using Shift and Enter
Individually select the cells F1 through H1 using Ctrl and Enter

In the name box type AHr

then for your formula

=LARGE(AHr,1)&LARGE(AHr,2)&LARGE(AHr,3)

hth

Mike

ps No you can't give it multiple n parameters

 

[MrKowz]

Hi, Im not looking for different ways to concatenate I just want to know is if the Large function can have multiples n´s.

Thank you.

It cannot

 

[barry houdini]

You can use this formula

=LARGE((A1:C1,F1:H1),{1;2;3})

"array entered" in a vertical array of 3 cells that will display the largest 3, one in each cell

 

[shg]

LARGE can have multiple n's, but there is no native function that will catenate an array result. For example,

      A- B- C- D- E- F-
  1   22 82 83 37 23 90
  2   90 83 82 37

A2:D2 contains the array formula

=LARGE(A1:F1, {1,2,3,4})

 

[AT--o]

Yea, I have tried that before but it only shows one number.

 

[AT--o]

=LARGE((A1:C1,F1:H1),{1;2;3})[/QUOTE]

Shows only one number

 

[barry houdini]

You can use the formula I suggested like this

Copy the formula
Copy into a single cell, e.g. J2
Press Enter
Select the range J2:J4
click in the formula bar
Hold down CTRL+SHIFT and press ENTER

shg'd suggestion works the same way except with commas for a horizontal range.....