ExcelTips: Amazing Array Formulas

Summary: Array formulas allow you to accomplish amazing things with your data, including things you cannot do with regular formulas. This guide gives you the information you need to master array formulas.

An array is a group of items that can, in some fashion, be treated as a whole. In Excel, an array formula is a special type of formula that allows you to perform calculations on huge amounts of data in a single operation. Array formulas, once properly understood, provide new and exciting ways that you can perform calculations with your data. In fact, there are some calculations that can be done with array formulas that would otherwise be impossible with regular Excel formulas.

In the pages of ExcelTips: Amazing Array Formulas, fifth edition, you'll find scores of tips that can help you better understand how to put array formulas to work with your data. Many of these tips have been pulled from past issues of the ExcelTips newsletter, but their inclusion in this single e-book brings a level of focus that is not available in any other single source.

Not all the information presented here is from past issues of ExcelTips, however. A good portion of the information has never been presented in any of our newsletters. You'll discover not only what array functions are and how to create them, but also different ways you can use them right away.

The fifth edition of ExcelTips: Amazing Array Formulas is greatly enlarged from the previous editions, with well over 100 pages of concise, focused content. There's too much information in this volume to list on this page, but feel free to take a look at the detailed table of contents.

ExcelTips: Amazing Array Formulas contains a wealth of information. We've tried to make sure that it contains anything and everything that you'll find useful as you work with array formulas in Excel. The book zeroes in on what you need to know and provides great ideas on how you can work with your data easier than ever before with array formulas.

ExcelTips: Amazing Array Formulas is provided in two formats: a Microsoft Word document and an Adobe Acrobat (PDF) document. You don't have to decide which you want, however; both versions are included! In these formats you enjoy the following features:

  • The ability to view, search, and print the book.
  • Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
  • The ability to select and copy sections of text, such as macro code.
  • Hyperlinks to internal content (in the book itself) and referenced resources on the Web.

Get Adobe Acrobat ReaderSince the electronic book is provided in Adobe Acrobat (PDF) format, you need to either have Acrobat or the free Adobe Acrobat Reader. Many computer systems already have the reader installed. If you do not, you can get it free, directly from Adobe.

ExcelTips: Amazing Array Formulas is immediately usable by all Excel users; the information it contains has been tested with Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019, but it will also work with much older versions of Excel. (Array formulas have been around for years and years in Excel.) Whatever version you are using, ExcelTips: Amazing Array Formulas provides a valuable resource for focused information that can't be matched by any other single source or computer book.

Description Download CD
ExcelTips: Amazing Array Formulas Buy Download
ISBN 978-1-61359-483-4 (1.6 MB)
Buy on CD
ISBN 978-1-61359-484-1 (112 pages)

You can also order ExcelTips: Amazing Array Formulas by calling our order line: 307-200-0450.