Prev Previous Post   Next Post Next
  #1   Report Post  
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! :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
list separator widman Excel Discussion (Misc queries) 3 November 5th 07 03:12 PM
Making my list look better-want blank separator row Jugglertwo Excel Discussion (Misc queries) 7 March 20th 07 03:55 AM
List Separator Kieran H Excel Programming 9 March 8th 07 12:59 PM
list separator Kieran H Excel Programming 1 February 26th 07 07:00 AM
list separator settings culkebas Excel Discussion (Misc queries) 2 December 22nd 05 08:26 AM


All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"