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
RE: obtaining value every 10th rows
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
=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
Never, but never question engineer's judgement