Discussion Re: Formula to populate every other cell while adding 19 as we go along a row in Excel
https://techcommunity.microsoft.com/t5/excel/formula-to-populate-every-other-cell-while-adding-19-as-we-go/m-p/1736326#M76657
<P><LI-USER uid="385033"></LI-USER> </P><P> </P><P>You want to link/lookup a value on another worksheet, but each formula row should increment 19 rows on the target/source worksheet?</P><P> </P><P>Attached is an example that I think will help. I wasn't sure exactly where you wanted the formula to appear and from where it should pull, so change range references to suit. Basically, you use the ROWS function to create a counter {0,1,2,3,4...} that is multiplied by 19.</P>Thu, 01 Oct 2020 18:22:30 GMTJMB172020-10-01T18:22:30ZFormula to populate every other cell while adding 19 as we go along a row
https://techcommunity.microsoft.com/t5/excel/formula-to-populate-every-other-cell-while-adding-19-as-we-go/m-p/1736274#M76655
<P>Is there a formula that will populate every other cell while keeping the letter the same but adding 19 as we go along. (Example=J2 then the next cell along would be J19) </P><P>I'm lifting the values from another page where the values are in column form.</P>Thu, 01 Oct 2020 18:09:38 GMThttps://techcommunity.microsoft.com/t5/excel/formula-to-populate-every-other-cell-while-adding-19-as-we-go/m-p/1736274#M7665516Teams2020-10-01T18:09:38ZRe: Formula to populate every other cell while adding 19 as we go along a row
https://techcommunity.microsoft.com/t5/excel/formula-to-populate-every-other-cell-while-adding-19-as-we-go/m-p/1736326#M76657
<P><LI-USER uid="385033"></LI-USER> </P><P> </P><P>You want to link/lookup a value on another worksheet, but each formula row should increment 19 rows on the target/source worksheet?</P><P> </P><P>Attached is an example that I think will help. I wasn't sure exactly where you wanted the formula to appear and from where it should pull, so change range references to suit. Basically, you use the ROWS function to create a counter {0,1,2,3,4...} that is multiplied by 19.</P>Thu, 01 Oct 2020 18:22:30 GMThttps://techcommunity.microsoft.com/t5/excel/formula-to-populate-every-other-cell-while-adding-19-as-we-go/m-p/1736326#M76657JMB172020-10-01T18:22:30Z