Forum Discussion
Using Array Formula C(olumns) and R(ows) times in excel formula
I'm looking to expand a formula that can accommodate building scenarios over a span of 5 years (columns) and 10 cases (rows). I can effectively handle the setup for one row and gen...
This is the same as HansVogelaar 's formula except that I have allowed the row and column indices, k₁ and k₂, to broadcast to build the 2D array of products.
= LET(
π, PI(),
k₁, SEQUENCE(rows, 1),
k₂, SEQUENCE(1, cols),
SIN(k₁*k₂ * π/4)
)
