*phew* just finished with it
well in step 27
- in a new column (J) you have to insert the formula "
=IF(I6>10,I6,0) " to find only the flights more than 10 minutes late , for All the flights in that sheet.
- then go to the new sheet you created (in which you copied and pasted all the airline names from cell a2 to a32)
-in column C , enter the formula "
=SUMIF(N9Flight!$C$6:$C$131,A2,N9Flight!$J$6:$J$131) " (where the J column range was that extra column you created in N9flight worksheet)
in step 32 ? thats simple
-filter the
number of flights greater than 6, ooh By the way place labels in a1 ( Airlines) b1 (No. of flights) and c1 (time delayed, or just
delayed) to make it clear for you !
-then u can continue with making a
stacked bar chart ! using the chart wizard