# an Excel formula

In Excel, I need write a formula in column L to get a data from Column A:

Cell L1 = A1
Cell L2 = A4
Cell L3 = A7
Cell L4 = A10
...
...

Any formula I can use in Column L?
###### Who is Participating?

Commented:
Slight adjustment to offset the 8 cells from row 1.,

=INDEX(R:R,4*(ROWS(R\$8:R8)-1)+8)

copied down
0

Commented:
Try:

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

copied down
0

Commented:
I assume there must be something more than just getting a value from another cell?  The formula is just ={cell}

Ie, in Cell L1 the formula is just =A1

If you have a text value that needs to be converted to a number you use =Value(A1)

If you are skipping to every third cell, Excel is smart enough if you drag copy the formula down.
0

Author Commented:
convergint,

I'm skipping to every third cell.  After making several ones, I highlighted those and drag the formula down, but it didn't work.  Do you know why?
0

Commented:
Did you try my formula?  It should do as you required.
0

Author Commented:
NB_VC,

I tried and it didn't work.  I attach the file, and could you put the formula into cells Z5-Z51?  Thanks!
0

Commented:
Don't see the attachment....
0

Author Commented:
here it is.
sample.xls
0

Author Commented:
Works!  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.