Thread: List separator
View Single Post
  #1   Report Post  
P-man P-man is offline
Junior Member
 
Posts: 4
Default List separator

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 the formula (array), Excel automatically uses the same separator symbol. Hence, when I choose several input areas, Excel interprets these as different arguments in the formula, which basically screws everything up!

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

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

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

Thanks for whatever help you can provide! :)