17. Using Super Formulas in Excel
Excel offers an amazing variety of formulas. This chapter covers some of the unorthodox formulas you can build in Excel. In this chapter, you discover the following:
• Using a formula to add the same cell across many sheets
• Using a formula to reference the previous sheet
• Editing multiple formulas into one
• Assigning a formula to a name
• Letting data determine the cell reference to use with the INDIRECT function
• Using a dynamic range with an offset
• Transposing relative column references to rows
• Using ROW() or COLUMN() to return an array of numbers
• Replacing thousands of formulas with one Ctrl+Shift+Enter (CSE) array formula
• Using one formula to return a whole range of answers
• Doing conditional ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
