Up up and array! : dynamic array formulas for Excel 365 and beyond
Record details
- ISBN: 9781484289655
- ISBN: 148428965X
- ISBN: 1484289668
- ISBN: 9781484289662
-
Physical Description:
1 online resource
remote - Publisher: New York, NY : Apress, [2023]
Content descriptions
Formatted Contents Note: | Chapter 1: Whats 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. |
Source of Description Note: | Description based on online resource; title from digital title page (viewed on January 05, 2023). |
Search for related items by subject
Subject: | Microsoft Excel (Computer file) -- Microsoft Excel (Computer file) Microsoft Excel (Computer file) -- Microsoft Excel (Computer file) Electronic spreadsheets Electronic spreadsheets |
Genre: | Electronic books. |