×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

obtaining value every 10th rows
3

obtaining value every 10th rows

obtaining value every 10th rows

(OP)
Lets say Column A I have a column full of data (lets say 100 data).  What formula do I need to put on B so I can easily drag it down to however many row so that it will obtain A10,A20,A30...,A100. ?  Am I making any sense?  I dont want to type in =A10, =A20 .... etc. manually.

Never, but never question engineer's judgement

RE: obtaining value every 10th rows

=IF(MOD(ROW(A1),10)=0,A1,"")

 

RE: obtaining value every 10th rows

=INDIRECT("A"&10*(CELL("row",B1)))

Put this formula in B1 and drag it down to return the value in A10, A20, etc.

-handleman, CSWP (The new, easy test)

RE: obtaining value every 10th rows

Many ways to skin a cat:

=INDEX($A:$A,10*ROW(A1))
or
=OFFSET($A$1,10*ROW(A1)-1,0)

I like the INDEX one because it is easy to understand, and the fastest. I also noted that using ROW(A1) is about 15% faster than CELL("row",A1)

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: obtaining value every 10th rows

(OP)
thank you guys.. I have not tried any of them yet.  I dont know which one to use yet.  Appreciate it!

Never, but never question engineer's judgement

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources