SOLVED

Date list from matrix reference

Copper Contributor

Hi,

 

I'd like to generate a data list from a matrix definition in a cell. In the image below try to show my question. B27 value is a matrix where it is the data list. B27 value could change.

 

Any suggestion for this?

 

Thanks,

 

Juan CL.

 

JuanCasLo_1-1663093396109.png

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@JuanCasLo 

Perhaps

=INDIRECT(B27)

@Sergei Baklan 

 

Oh! great! it works! thanks!

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@JuanCasLo 

Perhaps

=INDIRECT(B27)

View solution in original post