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?
jjxia2001Asked:
Who is Participating?
 
NBVCCommented:
Slight adjustment to offset the 8 cells from row 1.,


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

copied down
0
 
NBVCCommented:
Try:

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

copied down
0
 
convergintCommented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
jjxia2001Author 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
 
NBVCCommented:
Did you try my formula?  It should do as you required.
0
 
jjxia2001Author 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
 
NBVCCommented:
Don't see the attachment....
0
 
jjxia2001Author Commented:
here it is.
sample.xls
0
 
jjxia2001Author 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.

All Courses

From novice to tech pro — start learning today.