Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
list separator | Excel Discussion (Misc queries) | |||
Making my list look better-want blank separator row | Excel Discussion (Misc queries) | |||
List Separator | Excel Programming | |||
list separator | Excel Programming | |||
list separator settings | Excel Discussion (Misc queries) |