How can I create a reference to a rectangular range of cells that is a specified number of rows and columns from a cell or another range of cells?
How can I perform a lookup operation by keying off the right-most column instead of the left-most column in a table range?
I often download sales of a software product listed by country. I need to track revenues from Iran as well as costs and units sold, but the data about Iran isn’t always in the same location in the spread-sheet. Can I create a formula that will always pick up Iran’s revenues, costs, and units sold?
Each drug developed by my company goes through three stages of development. I have a list of the cost by month for each drug, and I also know how many months ...