Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Abbott Ira Katz
Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond
Cover
Front Matter
1. What’s an Array, Anyway?
2. Array Formula Basics
3. Dynamic Arrays: Time for Some Heavy Lifting
4. The SEQUENCE Function: Made to Order
5. UNIQUE: A Singular Function
6. SORT and SORTBY: The ABCs (and the CBAs)
7. The FILTER Function: Cutting the Data Down to Size
8. RANDARRAY: Unpredictably Useful
9. The Implicit Intersection Operator: The Function You’ll Probably Never Use
10. TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their Places
11. TOCOL and TOROW: Straightening Out the Data
12. WRAPCOLS and WRAPROWS: Giving Some Direction to the Data
13. VSTACK and HSTACK: What They’re About
14. CHOOSECOLS and CHOOSEROWS: Less Is More
15. TAKE and DROP: Selecting and Rejecting the Data
16. EXPAND: Bulking Up the Data
Back Matter
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Front Matter
Book cover of Up Up and Array!
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset