Excel 2010 Bible

Chapter 16: Introducing Array Formulas 359 The following formula uses the SUM function, with the preceding array constant as its ...

Part II: Working with Formulas and Functions 360 Array constant elements ....................................................... ...

Chapter 16: Introducing Array Formulas 361 To enter this array, select seven cells in a row and type the following (followed by ...

Part II: Working with Formulas and Functions 362 FIGURE 16.3 A 3 × 4 array entered into a range of cells. FIGURE 16.4 A 3 × 4 ar ...

Chapter 16: Introducing Array Formulas 363 array. Also, you must type the curly brackets when defining a named array constant; E ...

Part II: Working with Formulas and Functions 364 Working with Array Formulas ................................................... ...

Chapter 16: Introducing Array Formulas 365 The following rules apply to multicell array formulas. If you try to do any of these ...

Part II: Working with Formulas and Functions 366 Using Multicell Array Formulas ................................................ ...

Chapter 16: Introducing Array Formulas 367 FIGURE 16.8 Creating an array from a range. Creating an array constant from values in ...

Part II: Working with Formulas and Functions 368 Performing operations on an array ............................................. ...

Chapter 16: Introducing Array Formulas 369 Using functions with an array ....................................................... ...

Part II: Working with Formulas and Functions 370 FIGURE 16.12 Using the TRANSPOSE function to transpose a rectangular array. Gen ...

Chapter 16: Introducing Array Formulas 371 If you want to generate an array of consecutive integers, a formula like the one show ...

Part II: Working with Formulas and Functions 372 The following array formula does the job without using any intermediate formula ...

Chapter 16: Introducing Array Formulas 373 This formula works fine, but using an array formula is more efficient. The following ...

Part II: Working with Formulas and Functions 374 cell contains text. This new array is then passed to the SUM function, which re ...

Chapter 16: Introducing Array Formulas 375 post-test scores. Cell D17 contains a formula, shown here, that calculates the averag ...

Part II: Working with Formulas and Functions 376 The following array formula returns the smallest value in the Change column. Th ...

Chapter 16: Introducing Array Formulas 377 You can use a two-dimensional array in place of the lookup range. The following formu ...

...