Solved

an Excel formula

Posted on 2013-02-05
9
225 Views
Last Modified: 2013-02-05
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
Comment
Question by:jjxia2001
  • 4
  • 4
9 Comments
 
LVL 23

Expert Comment

by:NBVC
Comment Utility
Try:

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

copied down
0
 
LVL 10

Expert Comment

by:convergint
Comment Utility
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

by:jjxia2001
Comment Utility
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

by:NBVC
Comment Utility
Did you try my formula?  It should do as you required.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:jjxia2001
Comment Utility
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

by:NBVC
Comment Utility
Don't see the attachment....
0
 

Author Comment

by:jjxia2001
Comment Utility
here it is.
sample.xls
0
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
Comment Utility
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

by:jjxia2001
Comment Utility
Works!  Thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
This article will show you how to use shortcut menus in the Access run-time environment.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now