List separator

[P-man]

Hi all!

I have a quite annoying problem with my Excel.

The argument separator in the formulas, is equal to the list separator
which I think it should be.

However, when I want to choose several areas with input data for th
formula (array), Excel automatically uses the same separator symbol
Hence, when I choose several input areas, Excel interprets these a
different arguments in the formula, which basically screws everythin
up!

To give an example:
=large(F3:G18;J3:K15;2)

And yes, I have tried to manually change the symbol between the tw
input lists, and this does not provide any satisfactory result.

So basically, how can I change the setting to get one symbol separatin
several data input lists, and another symbol separating the argument
list?

Thanks for whatever help you can provide! :

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[P-man]

Try putting the non-contiguous range in a separate set of brackets.
So your example formula becomes =LARGE((E3:E16,G3:G13),2)

Perfect! This solved the problem.
Thank

+-------------------------------------------------------------------
+-------------------------------------------------------------------