[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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?
0
jjxia2001
Asked:
jjxia2001
  • 4
  • 4
1 Solution
 
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
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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


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

copied down
0
 
jjxia2001Author Commented:
Works!  Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now