Solved

an Excel formula

Posted on 2013-02-05
225 Views
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?
0
Question by:jjxia2001
• 4
• 4

LVL 23

Expert Comment

Try:

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

copied down
0

LVL 10

Expert Comment

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 Comment

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

LVL 23

Expert Comment

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

Author Comment

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

LVL 23

Expert Comment

Don't see the attachment....
0

Author Comment

here it is.
sample.xls
0

LVL 23

Accepted Solution

NBVC earned 500 total points
Slight adjustment to offset the 8 cells from row 1.,

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

copied down
0

Author Comment

Works!  Thanks!
0

Featured Post

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…