Howdy -

I've got a large number of 10-20 mb files with a column of 1 sec data
collected for most, but not all seconds in most, but not all hours. I'd
like to make 1 min and 1 hr averages of the rest of the data collected
in each time range at whichever sec and min occur first in (whichever)
hour. Various combinations of sorting and pivot tables have come to
naught due to the intermittency - I need big help, please!

Thanks a heap.


--
jra
------------------------------------------------------------------------
jra's Profile: http://www.excelforum.com/member.php...o&userid=30877
View this thread: http://www.excelforum.com/showthread...hreadid=505583