Questions answered in this chapter:
Given monthly sales for several products, how do I write a formula that returns the sales of a product during a specific month? For example, how much of Product 2 did I sell during June?
Given a list of baseball players’ salaries, how do I write a formula that yields the player with the highest salary? How about the player with the fifth-highest salary?
Given the annual cash flows from an investment project, how do I write a formula that returns the number of years required to pay back the project’s initial investment cost?
Suppose you have a worksheet with five thousand rows containing five thousand names. You need to find the name John Doe, which you know appears somewhere (and only ...