7. Array Formulas

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch7

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Array Formulas, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch7

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • array formulas;
  • “three-dimensional” array;
  • SUMIF formula;
  • ROW function;
  • indirect function

Summary

This chapter contains sections titled:

  • Introduction to Array Formulas

  • An Array Formula Example: Creating a Specialized SUMIF Formula

  • Evaluating Polynomials or Power Series Using Array Formulas

  • Using Array Formulas to Work with Lists

  • Sorting by Using an Array Formula

  • Another Example: Validating a CAS Registry Number