Untitled

mail@pastecode.io avatar
unknown
javascript
a year ago
182 B
1
Indexable
Never
=makearray(counta(A2:A),counta(B1:1),lambda(r,c,let(row,index(A2:A,r),col,index(B1:1,c),
          if(col="CMP",googlefinance(row),ifna(index(googlefinance(row,"price",col),2,2))))))