excel function

%3CLINGO-SUB%20id%3D%22lingo-sub-2048205%22%20slang%3D%22en-US%22%3Eexcel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2048205%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20was%20wondering%20if%20there's%20a%20function%20to%20select%20two%20numbers%20in%20the%20same%20column%2C%20and%20fill%20the%20remaining%20blank%20spaces%20between%20them%20with%20the%20incremental%20values%20from%20number%20one%20to%20number%20two%3F%20for%20example%3A%20the%20number%203%20being%20in%20A1%2C%20the%20number%206%20in%20A8%2C%20is%20there%20a%20function%20to%20fill%20the%20blank%20spaces%20between%20the%20two%20with%20the%20incremental%20values%20from%203%20to%206%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2048205%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2048336%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2048336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F924530%22%20target%3D%22_blank%22%3E%40jax_light%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20such%20sample%20it%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1%2B(%24A%248-%24A%241)%2F(ROW(%24A%248)-ROW(%24A%241))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ein%20A2%20and%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

i was wondering if there's a function to select two numbers in the same column, and fill the remaining blank spaces between them with the incremental values from number one to number two? for example: the number 3 being in A1, the number 6 in A8, is there a function to fill the blank spaces between the two with the incremental values from 3 to 6?

1 Reply

@jax_light 

For such sample it could be

=A1+($A$8-$A$1)/(ROW($A$8)-ROW($A$1))

in A2 and drag it down