Problem averaging periods of time in excel

[chriswenk]

Hello everyone,

I just stumbled across this site while searching for some help with an excel problem that I am having. This could just be a very simple issue, or user error, but I'm not sure. Anyway, the problem is that I have two (quite large) sets of data (large as in I am reaching the 2^16 row per worksheet limit). The data I have is 9 months worth of wind speed trends from a meteorological tower we own, and 9 months of similar data from an observation station run by the FAA. However, our data is measured in 10-minute intervals while the FAA's data is in 5-minute intervals. In order to properly import this data into another program that I am using, the FAA data must be changed to 10-minute intervals. Here is the setup of my worksheet:



A	B	C	D
Date	Time (HH:MM)	Wind Direction (degrees)	Wind Speed (m/s)
7/1/2007	0:00	270	7.8
7/1/2007	0:05	260	7.5
7/1/2007	0:10	280	7.6

Any help would be greatly appreciated!
Thanks,
Chris

 

[CPA Nerd]

This isn't a very robust solution, but in an empty column enter either an "x" or a "y" depending on whether you want to export the data in that row. (If it is really every other row that you need to export, you should be able to enter one "x" and one "y" and then copy down.) Then, sort by that column and it will put all of the rows you want to import together.