referencing question

  • Thread starter Thread starter gtjerry80
  • Start date Start date
G

gtjerry80

i have a data dump in which i want to extract the data in the first
column for every 4th row. i am currently extracting it to a second
worksheet. how do i reference every forth row so i don't have to
manually reference it? does this even make sense? thanks in advance
for any help!

cj
 
With your data in Col A starting A1, in B1 put the following formula and copy down:-

=OFFSET($A$1,(ROW()*4)-1,)

Then select Col B, do Edit / Copy, then Edit / Paste Special / Values
 
CJ,

One of these

=OFFSET($A$1,ROW(A1)*4-1,0,1,1)
=OFFSET($A$1,ROW(A1)*4-4,0,1,1)

Copy down with fill handle or paste.
 
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, array
enter into a column of sufficient cells to accommodate the return values

=ArrayAlternates(ArrayAlternates(A1:A100,False),False)

Alan Beban
 
Back
Top