Need help with excel. What is the formula for the whole column for D. Rows that

Question

Need help with excel. What is the formula for the whole column for D. Rows that say "Mango Air" and "Econ Air"? Using the IF function. Not sure how to get those to appear using formula/the IF function.

Projects EX-2 1 Using Functions (continued) PrjEX-2 Excel Sarah Smith FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Formatting nsert LE Conditional Arial 14 A A Genera Format as Table Delete Sort & Find & B I U Format Filter Select Cell Styles Editing Clipboard Font Alignment Celis Number Styles G15 Aereo Groupo S.A. Student's Name) Mango Air Econo Air 3 Destination Number of Flights Number of Flights Most Flights 4 Costa Rica 125 135 Econo Air 157 5 Panama 143 Mango Air 221 Mango Air 6 Mexico 235 Econo Air 7 Venezuela 93 101 Econo Air 8 Nicaragua 85 Mango Air El Salvador 137 Econo Air 10 Colombia 1057 1029 12 Minimum 235 13 Maximum 151 147 14 Average 16 Countries 17 Aereo Source Sheet BB READY 4:07 PM Media Technics

Explanation / Answer

INDEX($B$2:$C$2,0,MATCH(MAX($B4:$C4),$B4:$C4,0))

Put this function in most flights column and hit enter you will get tha maximum value. Then just drag the cell till the bottom to apply on all calls of column.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---