Thread: Need to seperate every 6th row out of a column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Need to seperate every 6th row out of a column?
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
---
"DLN" wrote:
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.
Reply With QuoteReply With Quote