Fill bar

[ab1041]

I need to paste the following range: into consecutive cells:
=a1,=a4,=a7, =a10 down to about =a1230. When I use the fill handle
after about 3 cells, Excel doesn't seem to understand that I want the
cell reference sequence to increment by 3 each time. Is there a way to
make that happen?

 

[Biff]

Hi!

Try this:

=INDEX(A:A,((ROWS($1:1)-1)*3)+1)

Drag copy down as needed.

Biff