tricky problem with 14800 rows (collating figures)
 

Hi,
I'm trying to sort through a very large amount of data, and to get averages
from it. (14800 ows in the full version !!). What I need to do is

1) Find out how many times each DELAY (column B1) appears for each AIRLINE
(A1) and give a total for each airlines (This is to show which delay affects
individual airlines the most)

2) Add up the CPU time spent on delays for each airline

3) Collate the number of ABENDs-periairline, and CPU time-per-airlines in to
a grand total

I need hedlp with this one as it is totally out of my depth.

A1 B1 C1
AIRLINE DELAY TIME
______ _____ ____
Air Maroc ALTGET - 0.19
CLIMM - 0.55
ALTGET - 0.06
FLPOSS - 0.04
FPCLC - 0.08
NALSL - 0.63
PARMAA - 0.02
PRTPLN - 2.69
RCRFFL - 0.02
SECDES - 0.03
TRGIN1 - 0.02
XSPTPT - 0.01
ZCRTAB - 0.02
Total 4.36

Air india ALTGET - 0.27
CH2INT - 0.03
CLCALC - 0.02
CLIMM - 0.65
FLPDT - 0.07
FPCLC - 0.02
PARMWX - 0.15
PRTPLN - 0.3
VERALT - 0.01
YSTART - 0.04
Total


Thanks for reading this - i hope you can help,
Brgds - Nick

tricky problem with 14800 rows (collating figures)
 

Hi
Have you had a look at Data / Sort,
Data / subtotals and Data / filtering

HTH
Michael

"daviesnc" wrote:

Hi,
I'm trying to sort through a very large amount of data, and to get averages
from it. (14800 ows in the full version !!). What I need to do is

1) Find out how many times each DELAY (column B1) appears for each AIRLINE
(A1) and give a total for each airlines (This is to show which delay affects
individual airlines the most)

2) Add up the CPU time spent on delays for each airline

3) Collate the number of ABENDs-periairline, and CPU time-per-airlines in to
a grand total

I need hedlp with this one as it is totally out of my depth.

A1 B1 C1
AIRLINE DELAY TIME
______ _____ ____
Air Maroc ALTGET - 0.19
CLIMM - 0.55
ALTGET - 0.06
FLPOSS - 0.04
FPCLC - 0.08
NALSL - 0.63
PARMAA - 0.02
PRTPLN - 2.69
RCRFFL - 0.02
SECDES - 0.03
TRGIN1 - 0.02
XSPTPT - 0.01
ZCRTAB - 0.02
Total 4.36

Air india ALTGET - 0.27
CH2INT - 0.03
CLCALC - 0.02
CLIMM - 0.65
FLPDT - 0.07
FPCLC - 0.02
PARMWX - 0.15
PRTPLN - 0.3
VERALT - 0.01
YSTART - 0.04
Total


Thanks for reading this - i hope you can help,
Brgds - Nick