I have data like this below. I am using Excel 2000.
Year Month 210000 236000 237000
1990 1 2 341 188
1990 2 0 325 169
1990 3 1 343 174
1990 4 3 321 263
1990 5 1 354 305
1990 6 1 375 375
1990 7 2 415 211
1990 8 2 441 227
1990 9 5 430 205
1990 10 3 425 205
1990 11 2 420 198
1990 12 2 419 183
1991 1 2 367 136
1991 2 2 372 118
1991 3 2 397 170
1991 4 0 452 294
1991 5 2 488 359
1991 6 2 491 405
1991 7 2 514 401
1991 8 2 519 401
1991 9 2 511 370
1991 10 6 502 376
1991 11 6 460 324
1991 12 6 420 234
I need to get it to look like this with the average anuual number in the spaces below.
Year 210000 236000 237000
1990
1991
If someone can give me a way to go about this I would extremly appreciate it.
Thanks,
Mike
Year Month 210000 236000 237000
1990 1 2 341 188
1990 2 0 325 169
1990 3 1 343 174
1990 4 3 321 263
1990 5 1 354 305
1990 6 1 375 375
1990 7 2 415 211
1990 8 2 441 227
1990 9 5 430 205
1990 10 3 425 205
1990 11 2 420 198
1990 12 2 419 183
1991 1 2 367 136
1991 2 2 372 118
1991 3 2 397 170
1991 4 0 452 294
1991 5 2 488 359
1991 6 2 491 405
1991 7 2 514 401
1991 8 2 519 401
1991 9 2 511 370
1991 10 6 502 376
1991 11 6 460 324
1991 12 6 420 234
I need to get it to look like this with the average anuual number in the spaces below.
Year 210000 236000 237000
1990
1991
If someone can give me a way to go about this I would extremly appreciate it.
Thanks,
Mike