Forum Discussion
Solved
[Excel 365] Positioning a list of values as a "staircase" with dynamic array
Good day dear Excel community I'm scratching my head around a formula I need to write to create the range on the right with a dynamic array. I need to do the following transformation using a ...
It's a rare occasion that MUNIT gets some work.
=LET(r,ROWS(Input),matrix,MUNIT(r)*Input,CHOOSECOLS(matrix,INT(SEQUENCE(r*rep,,MIN(Input),1/rep))))
It's a rare occasion that MUNIT gets some work.
=LET(r,ROWS(Input),matrix,MUNIT(r)*Input,CHOOSECOLS(matrix,INT(SEQUENCE(r*rep,,MIN(Input),1/rep))))
Patrick2788 : amazing. I didn't even know there was a MUNIT function in Excel. It takes me back years ago to math class!
Thanks for the fantastic help
- You're welcome! Glad to help.
