View Single Post
  #1   Report Post  
z.entropic
 
Posts: n/a
Default incrementing column symbols orthogonally?

I have two formulas in two neighboring cells in the same column:
=A$1
=C$1

Is there a simple way or setting to copy this scheme to a cell block below
these two cells dragging and to increment the column symbol by two or more
letters? Here's an example:

I have:
=A$1
=C$1
------
I'd like to get below it:
=E$1
=G$1
=I$1
=K$1
....

z.entropic