geometric progression

%3CLINGO-SUB%20id%3D%22lingo-sub-2643144%22%20slang%3D%22en-US%22%3Egeometric%20progression%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643144%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20repeat%20data%20in%20a%20geometric%20pattern%20e.g.%20repeat%20something%20in%20cell%201%2C2%2C4%2C8%20repeating%20the%20same%20word.%20but%20I%20would%20also%20like%20it%20to%20work%20if%20I%20started%20it%20in%20row%2020%20then%20it%20would%20be%2020%2C21%2C23%2C27%2C35%20if%20anyone%20would%20know%20how%20to%20write%20a%20formula%20like%20this%20that%20would%20be%20great%20thankyou%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2643144%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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,27,35 if anyone would know how to write a formula like this that would be great thankyou 

0 Replies