Thread: Matrix in cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Matrix in cells

Maybe you could try this:
D1: contains this text- A1:C3
E1: =INDEX(INDIRECT(D1),2,3)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Gilles P (FR)" wrote:

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