Over 10 mio. titler Fri fragt ved køb over 499,- Hurtig levering Forlænget returret til 31/01/25

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

Bog
  • Format
  • Bog, hæftet
  • Engelsk
  • 248 sider

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



Læs hele beskrivelsen
Detaljer
  • SprogEngelsk
  • Sidetal248
  • Udgivelsesdato02-12-2022
  • ISBN139781484289679
  • Forlag Apress
  • FormatHæftet
Størrelse og vægt
  • Vægt440 g
  • Dybde1,3 cm
  • coffee cup img
    10 cm
    book img
    17,8 cm
    25,4 cm

    Findes i disse kategorier...

    Machine Name: SAXO084