Forum Discussion
geometric progression
I am trying to repeat data in a geometric pattern e.g. repeat something in cell 1,2,4,8 repeating the same word. but I would also like it to work if I started it in row 20 then it would be 20,21,23,2...
Using Excel 365 or 2021.
= LET(
offset, ROW()-1,
k, SEQUENCE(21,,0),
offset+2^k)It finishes in row 40 with a value of 1,048,595