Re: Sorting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Excel uses a windows setting--the list separator under Regional settings.

Most in the USA use a comma. Most in Europe use a semicolon.

Svilen Pachedzhiev wrote:
>
> Thank you Herbert! Exatly what i needed!
>
> But I have one more question: In your formulas you use "," as a separator,
> but my Excel 2003 SP2 wants ";". Do you have any idea why is that?
>
> Regards,
>
> Svilen
>
> "Herbert Seidenberg" <herbds7-msxls@xxxxxxxxx> wrote in message
> news:1128230035.913895.15680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Assuming your data looks like this:
> Item T1 T2 T3 T4
> A 0.527 0.291 0.369 0.160
> B 0.557 0.182 0.152
> C 0.619 0.494 0.565 0.508
> D 0.093 0.596
> E 0.095 0.207 0.692
> F 0.363 0.244 0.095 0.150
> G 0.018 0.421 0.057
>
> 0.159 0.211 0.113 0.122
> G B D G
> E E F F
> F F B A
>
> Select the 8 by 5 array and
> Insert > Name > Create > Top Row
> The average of the 3 smallest values in T1 is 0.159
> The underlying formula is
> =AVERAGE(SMALL(T1,{1,2,3}))
> The matching items are G, E and F and the formulas are
> =INDEX(Item,MATCH(SMALL(T1,1),T1,0))
> =INDEX(Item,MATCH(SMALL(T1,2),T1,0))
> =INDEX(Item,MATCH(SMALL(T1,3),T1,0))
> Fill the rest of the array by substituting the proper T()
> The blanks in the array are where the negative numbers were.
> Name all the original numbers array_a and use the array formula
> =IF(array_a>=0,array_a,"") Shift+Cntrl+Enter to create a second
> array and Copy > Paste Special Values back to the first array.

--

Dave Peterson
.

Relevant Pages

  • Re: byteorder helpers and void * (was: Re: [PATCH 01/21] lib: add byteorder helpers for the aligned
    ... points to an array of bytes? ... arch to wire up it's get_unalignedmacro depending on its endianness, ... Sony Technology and Software Centre Europe ... A division of Sony Service Centre (Europe) N.V. ...
    (Linux-Kernel)
  • Re: Elegantes Splitten
    ... dient als Trennzeichen und es soll daraus ein Array gemacht ... dass ein Semicolon auch eingegeben werden ...
    (de.comp.lang.java)
  • Re: Creating a variable variable name o_O
    ... I am trying to make a loop to make small chunks of an array instead of a single large array. ... make sure you have the semicolon inside the regular expression in sprintf. ...
    (comp.soft-sys.matlab)
  • Re: Parsing a string into an array?
    ... spliton the semicolon and then loop through the array and use split (on ... Take the second value from that operation and put it in an array (or use it ... I'm using HTTPRequest to download a page of stock prices from ADVFN. ...
    (microsoft.public.excel.programming)
  • Re: Array of formulas (regional difference)
    ... In Europe, f you examine a formula in a spreadsheet you'll ... are stuffed into an array. ... Prev by Date: ...
    (microsoft.public.excel.programming)