Quote:
Originally Posted by ArviLaanemets
Maybe something like this!
|
Hello,
yes this could be a solution. It is a solution if I store the matrix data in a physical matrix. Is it possible to have the corresponding matrix as a virtual matrix - without storing it in another physical matrix?
Can I access data by VLookUp() to get the values of each line?
If I try it I get an error "Value!" (as I already got plenty times without understanding the reason...). Can you tell me why?
Can you explain a little bit how it works?
You are using a filter function but the formulas are completely new to me...
Thanks