automatically averaging

[den748]

greetings,

I am having difficulty making a macro that when run will go through
worksheet and look in the first column which is in date-time format bu
there are no seconds in the data. I need to do minute averages, i nee
the macro to look at the data and then make a new worksheet in the sam
file with just the minutly averaged data. Any suggestions please help
attatched is an example of the file.

Dennis O'Donnell
Millersville University Meteorolog

 

[Frank Kabel]

Hi
can you post some more detail. e.g. some example rows of data (plain
text - no attachments please)

 

[den748]

Date & Time Uni
ID 0.3-0.4u 0.4-0.491u 0.492-0.6u 0.6-0.701u 0.702-0.8u >0.8u
1/9/2004 0:00 1 1469 205 114 22 16 23
1/9/2004 0:00 1 1475 196 115 31 9 22
1/9/2004 0:00 1 1452 177 112 36 6 24
1/9/2004 0:00 1 1467 182 128 25 13 22
1/9/2004 0:00 1 1520 180 125 28 8 26
1/9/2004 0:00 1 1524 191 105 31 10 23
1/9/2004 0:00 1 1434 190 115 24 15 16
1/9/2004 0:00 1 1485 183 114 24 5 21
1/9/2004 0:00 1 1508 187 115 22 14 21
1/9/2004 0:00 1 1458 192 120 27 8 19
1/9/2004 0:00 1 1574 210 108 31 10 29
1/9/2004 0:00 1 1635 175 119 29 13 21
1/9/2004 0:00 1 1540 188 112 19 18 19
1/9/2004 0:00 1 1475 220 107 30 10 27
1/9/2004 0:00 1 1530 206 109 39 9 21
1/9/2004 0:00 1 1541 208 131 29 6 35
1/9/2004 0:00 1 1438 178 106 29 13 17
1/9/2004 0:00 1 1460 217 91 31 9 24
1/9/2004 0:00 1 1464 198 94 21 13 18
1/9/2004 0:00 1 1565 210 118 20 9 14
1/9/2004 0:00 1 1517 198 90 19 9 16
1/9/2004 0:00 1 1474 194 107 30 10 28
1/9/2004 0:00 1 1539 185 101 28 11 20
1/9/2004 0:00 1 1484 167 107 23 6 20
1/9/2004 0:00 1 1410 188 108 29 13 19
1/9/2004 0:00 1 1467 180 111 29 10 23
1/9/2004 0:00 1 1508 198 116 36 10 21
1/9/2004 0:00 1 1399 189 103 25 3 19
1/9/2004 0:00 1 1526 169 100 25 10 27
1/9/2004 0:00 1 1493 201 99 22 12 23
1/9/2004 0:01 1 1451 190 83 31 12 21
1/9/2004 0:01 1 1463 169 89 21 5 22
1/9/2004 0:01 1 1409 175 100 28 10 17
1/9/2004 0:01 1 1417 182 116 23 11 18
1/9/2004 0:01 1 1491 200 104 38 10 19
1/9/2004 0:01 1 1439 168 102 32 12 16
1/9/2004 0:01 1 1446 176 84 32 12 24
1/9/2004 0:01 1 1299 197 98 21 10 21
1/9/2004 0:01 1 1444 166 117 22 6 26
1/9/2004 0:01 1 1397 188 89 32 8 25
1/9/2004 0:01 1 1468 181 101 23 11 15
1/9/2004 0:01 1 1413 170 106 26 7 22
1/9/2004 0:01 1 1407 192 89 28 17 28
1/9/2004 0:01 1 1395 147 82 19 6 28
1/9/2004 0:01 1 1510 190 102 23 6 19
1/9/2004 0:01 1 1397 182 83 30 7 18
1/9/2004 0:01 1 1451 161 88 24 7 15
1/9/2004 0:01 1 1412 158 105 25 13 16
1/9/2004 0:01 1 1390 162 100 34 4 10
1/9/2004 0:01 1 1525 171 99 29 11 20
1/9/2004 0:01 1 1433 171 90 14 8 18
1/9/2004 0:01 1 1426 181 103 23 14 30
1/9/2004 0:01 1 1427 175 103 30 11 20
1/9/2004 0:01 1 1352 171 74 22 7 21
1/9/2004 0:01 1 1266 161 112 20 15 22
1/9/2004 0:01 1 1470 195 92 37 9 13
1/9/2004 0:01 1 1364 185 102 23 14 20
1/9/2004 0:01 1 1342 183 94 35 6 14
1/9/2004 0:01 1 1325 150 110 23 9 25
1/9/2004 0:01 1 1287 162 79 26 8 20
1/9/2004 0:02 1 1353 186 93 28 10 10
1/9/2004 0:02 1 1308 162 82 21 3 13
1/9/2004 0:02 1 1345 160 79 27 13 20
1/9/2004 0:02 1 1402 131 90 34 9 18
1/9/2004 0:02 1 1309 180 87 19 10 14
1/9/2004 0:02 1 1283 167 92 27 7 21
1/9/2004 0:02 1 1280 143 84 24 14 16
1/9/2004 0:02 1 1358 173 85 20 10 13
1/9/2004 0:02 1 1372 163 97 16 9 25
1/9/2004 0:02 1 1427 150 99 24 10 20
1/9/2004 0:02 1 1402 177 102 31 8 22
1/9/2004 0:02 1 1441 168 88 29 9 37
1/9/2004 0:02 1 1363 166 90 30 10 23
1/9/2004 0:02 1 1352 165 110 33 8 36
1/9/2004 0:02 1 1270 151 85 24 12 25
1/9/2004 0:02 1 1334 170 79 19 11 19
1/9/2004 0:02 1 1370 155 92 27 8 25
1/9/2004 0:02 1 1288 137 83 27 3 16
1/9/2004 0:02 1 1304 165 84 28 13 22
1/9/2004 0:02 1 1304 157 71 21 10 14
1/9/2004 0:02 1 1353 177 108 26 7 18
1/9/2004 0:02 1 1245 153 80 23 7 15
1/9/2004 0:02 1 1358 161 97 27 8 16
1/9/2004 0:02 1 1316 142 110 23 11 16
1/9/2004 0:02 1 1293 166 84 33 13 11
1/9/2004 0:02 1 1212 155 72 22 7 22
1/9/2004 0:02 1 1268 173 87 33 8 20
1/9/2004 0:02 1 1216 155 68 27 7 17
1/9/2004 0:02 1 1231 136 78 26 9 20
1/9/2004 0:02 1 1313 151 91 22 10 16
1/9/2004 0:03 1 1243 145 81 25 11 30
1/9/2004 0:03 1 1209 135 74 19 7 20
1/9/2004 0:03 1 1264 159 87 28 12 23
1/9/2004 0:03 1 1270 152 78 22 11 2

 

[Dave Peterson]

It's kind of difficult to see what column is what, but you may want to
investigate a pivottable.

You can group items by:
years
quarters
months
days
hours
minutes
seconds.

And you don't have to include the seconds.

If you want to learn more about pivottables, here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx