[I accidentally hit some keystroke which posted this post before I was ready, so can't seem to edit the subject. Anyway, in case you're somehow reading this post...
How can I achieve what the formula in E23 is doing, more simply?
i.e. repeat the number in E20, the number of times given in the cell below, then the number in F20 repeated the number of times in the cell below, and so on (I have about 30 columns).
How can I achieve what the formula in E23 is doing, more simply?
i.e. repeat the number in E20, the number of times given in the cell below, then the number in F20 repeated the number of times in the cell below, and so on (I have about 30 columns).
Cell Formulas | ||
---|---|---|
Range | Formula | |
E21 | E21 | =COUNTA(tb_Attribute1_levels[Attribute1_levels]) |
F21 | F21 | =COUNTA(tb_Attribute2_levels[Attribute2_levels]) |
E23:M23 | E23 | =HSTACK(SEQUENCE(1,E8,E7,0),SEQUENCE(1,F8,F7,0)) |
Dynamic array formulas. |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
Attribute1_levels | =tb_Attribute1_levels[Attribute1_levels] | E21 |
Attribute2_levels | =tb_Attribute2_levels[Attribute2_levels] | F21 |
Last edited: