Du er ikke logget ind
Beskrivelse
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