Thread: creating the pattern C7,C14,C21...

I think that

Originally Posted by martindwilson

try
=INDIRECT("C"&ROWS($A$1:A1)*7)

is a good approach to solve the question at original post

OR
an alternative is

=INDEX(C:C,ROWS($1:1)*7)
or
=INDEX(C1:C100,ROWS($1:1)*7)