Need to seperate every 6th row out of a column?

D

DLN

I'm look at hourly weather data for the last 6 months. I need to find a way
to take only one piece of data from one column but every 6th hour and put in
a seperate column for further anaylis.

Say the data I need to look at f6, f12, f18, etc through fwhatever. Is
there a 'formula' and/or way to have Excel cut these cells, then paste them
into consecutive rows such as M1, M2, M3 etc through Mwhatever?

So far I've got about 4500 lines to go through for 25 different sites.
HELP.
 
M

Max

One way to do it
In M1: =OFFSET(F$6,ROWS($1:1)*6-6,)
Copy down as far as required

Adapt to suit ..
Anchor: F6 (change this to suit where is the 1st source data cell)
Step: 6 in the part: *6-6 (change this to suit your desired step)
Do not change the incrementer: ROWS($1:1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning every 7th row of a column 8
Seperate text and numbers in a column? 6
average every 6th cell in a column 9
seperate first 2 lines of column in seperate columns in same row 2
How do I automatically create lists from column topics in a chart 0
How do I pull out every nth value from a column of data in excel? 8
Sum Every Third Column In A Row with 68 Columns 4
Sum every 6th cell in a row. 3

Top