Up Up and Array! : Dynamic Array Formulas for Excel 365 and Beyond
- Format
- Bog, hæftet
- Engelsk
- 248 sider
Normalpris
Medlemspris
- Du sparer kr. 50,00
- Fri fragt
-
Leveringstid: 7-9 Hverdage (Sendes fra fjernlager) Forventet levering: 02-03-2026
- Kan pakkes ind og sendes som gave
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
Detaljer
- SprogEngelsk
- Sidetal248
- Udgivelsesdato02-12-2022
- ISBN139781484289679
- Forlag Apress
- MålgruppeFrom age 0
- FormatHæftet
Størrelse og vægt
10 cm
Anmeldelser
Vær den første!