extracting values from an array

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
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
:)
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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
 
Upvote 0
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
 
Upvote 0
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 .....
 
Upvote 0
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
 
Upvote 0
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* !
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top