Thread: Matrix in cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilles P (FR)
 
Posts: n/a
Default Matrix in cells

Thanks for your 3 answers that open new ways, and answers my question,

but don't help me to resolve my hidden goal, because I hoped by this way to
avoid the denial of use a function in graph series definition....

The goal was to have
a graph series definition for datas as "=A1"
And to have in A1 a matrix of datas...

Thanks again

Gilles P (FR)



"Dana DeLouis" a écrit :

D1 {= A1:C3}

As an alternative, you could add the matrix to a range name.
Insert | Name | Define...

And add say "Tbl", with a value of ={1,5,9;2,6,10;3,7,11}

Then in E1: =INDEX(Tbl,2,3)
returns 10
HTH. :)
--
Dana DeLouis
Win XP & Office 2003


"Gilles P (FR)" <Gilles P wrote in message
...
Hi,
Is there a way to obtain a matrix in a cell ?
A B C
1 1 5 9
2 2 6 10
3 3 7 11

One way (that doesn't work ....)
formula in D1 {= A1:C3} that display as result: 1 (contain in A1)
And my goal is to have in E1 the result: 10
with a formula in E1 like =index(D1;2;3)

Thanks

Gilles P