Thanks:  0
Likes:  0

# Thread: extracting values from an array

1. 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. 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. 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. 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...

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 .....

5. 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?

6. 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. 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 ]

## User Tag List

#### Posting Permissions

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