Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond - Softcover

Katz, Abbott Ira

 
9781484289679: Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond
Softcover
ISBN 10: 1484289676 ISBN 13: 9781484289679
Publisher: Apress, 2022

Synopsis

Chapter 1: What's An Array, Anyway?

Chapter 2: Array Formula Basics

Chapter 3: Dynamic Arrays -- Time for Some Heavy Lifting

Chapter 4: The SEQUENCE Function: Made to Order

Chapter 5: UNIQUE -- A Singular Function

Chapter 6: SORT and SORTBY: The ABCs (and the CBAs)

Chapter 7: The FILTER Function: Cutting the Data Down to Size

Chapter 8: RANDARRAY: Unpredictably Useful

Chapter 9: The Implicit Intersection Operator: The Function You'll Probably Never Use

Chapter 10: TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their Places

Chapter 11: TOCOL and TOROW -- Straightening Out the Data

Chapter 12: WRAPCOLS and WRAPROWS: Giving Some Direction to the Data

Chapter 13: VSTACK and HSTACK: What They're About

Chapter 14: CHOOSECOLS and CHOOSEROWS: Less is More

Chapter 15: TAKE and DROP: Selecting and Rejecting the Data

Chapter 16: EXPAND: Bulking Up the Data

"synopsis" may belong to another edition of this title.

Publisher
Apress
Publication date
2022
Language
English
ISBN 10 
1484289676
ISBN 13 
9781484289679
Binding
Paperback
Number of pages
248

Other Popular Editions of the Same Title

9781484289655: Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond

Featured Edition

ISBN 10:  148428965X ISBN 13:  9781484289655
Publisher: Apress, 2022
Softcover