How do I select every nth row?

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

Hi

I have a long list of data.
Every fourth row contains the sort of data (ID, name, points...)
Unfortunately the data is all in one long column.

Can someone tell me how to select out every fourth row?
Maybe something that can give me the row number modulo 4?

My overall goal is to move this data into an Access table, but
I'm having trouble because of the format.

Thanks.

Ray.
 
If your data starts in A2 and you want A2, A6, A10 and so on, use a help
column adjacent and next to the first cell with data use

=MOD(ROW(1:1),4)=1

copy down

if you want A5, A9, A13 use

=MOD(ROW(1:1),4)=0

after you have copied down the formula to the end apply
data>filter>autofilter, filter on TRUE in the help column, select the
visible range, press F5, select special and visible cells only, copy and
paste somewhere else, there's your data


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Hey thanks a lot.
That was really great.
I learned a lot from your example.
Thanks for taking the time.

btw, I couldn't copy and paste everything in one shot. It said
something about the data being too complex. I don't think that it
was really too complex, just too much of it. I had no trouble
when I tried to copy 4-5000 lines at a time.

Thanks again. I'm impressed.

Ray
 
Back
Top