Quote:
Originally Posted by 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 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! :)
|
This is possibly something to do with your Windows regional settings rather than your Excel settings.
Have a look at this thread and see if it's of any help to you.
http://www.excelbanter.com/showthread.php?t=19634