Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: extracting values from an array

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Evening all,

    if I have an array as a result of a formula, say {1,2,3}

    or even just a cell with {1,2,3} in it as an array

    how do I get a different cell to return those 3 values : 1 2 3 ?

    =OFFSET and =INDEX don't like me very much and were very unco-operative

    merci beaucoup,
    Chris

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How are you getting on array of values in one cell? If you can seperate them into several cells everything would be much easier.

    Dave

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dave,

    from a formula

    however, I just saw the earlier posting which is very similar, which I'll merge into if I have any further problems

    cheers
    Chris

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi Chris.

    correct me you wat a result to go in one cell thats sya 3 answers in one cell..

    if so..


    =sum(X) & " " & Sum(y) & " " & Sum(z)

    this is not a real formula but will this not do the job...

    & links results//

    say A1 = Chris
    say B1 = D

    then = A1 & " " & B1 (say in C1)

    This will result/return in in C1

    Chris D

    does this help or anyone know better .....
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,993
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-02 10:39, Chris Davison wrote:
    Hi Dave,

    from a formula

    however, I just saw the earlier posting which is very similar, which I'll merge into if I have any further problems

    cheers
    Chris
    Yep, very much so. Mark offered using a named array.

    What kind of formula does produce your constant array?

    Aladin

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    a formula that returns 5 random numbers from a population of 50....

    I have an answer, but it's an array.

    I can't get the **** thign to *show* !

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-02 12:49, Chris Davison wrote:
    a formula that returns 5 random numbers from a population of 50....

    I have an answer, but it's an array.

    I can't get the **** thign to *show* !
    If the elements of the resultant array are separated by commas (,) then prior to entering your formula select 5 adjacent cells on a single row, type your formula, and press the Control+Shift+Enter key combination.

    If the elements of the resultant array are separated by semicolons ( then prior to entering your formula select 5 adjacent cells on a single column, type your formula, and press the Control+Shift+Enter key combination.

    For more info on array formulas see the Excel Help topic for "About array formulas and how to enter them". Pay special attention to the paragraph that begins with "To calculate multiple results with an array formula..."

    [ This Message was edited by: Mark W. on 2002-04-02 14:50 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •