LEADER 03619nam  2200541Ia 450 
001 9910814971103321
005 20240314030801.0
010   $a1-61547-209-6
010   $a1-61547-109-X
035   $a(CKB)2550000001132869
035   $a(OCoLC)859157827
035   $a(CaPaEBR)ebrary10745692
035   $a(SSID)ssj0001075882
035   $a(PQKBManifestationID)11660092
035   $a(PQKBTitleCode)TC0001075882
035   $a(PQKBWorkID)11252202
035   $a(PQKB)11273226
035   $a(MiAaPQ)EBC1340878
035   $a(Au-PeEL)EBL1340878
035   $a(CaPaEBR)ebr10745692
035   $a(CaONFJC)MIL532578
035   $a(EXLCZ)992550000001132869
100   $a20130228d2013      uy         0
101 0 $aeng
135   $aurcn|||||||||
181   $ctxt
182   $cc
183   $acr
200 10$aCtrl+shift+enter$b[electronic resource] $emastering Excel array formulas /$fMike Girvin
210   $aUniontown, OH $cHoly Macro! Books$d2013
215   $a1 online resource (353 p.) 
300   $aSubtitle from cover.
300   $aIncludes index.
311   $a1-61547-007-7 
311   $a1-306-01327-5 
327   $aFront Cover -- Title page -- Copyright page -- Contents -- Dedications -- About the Author -- Acknowledgements -- Introduction -- Chapter 1: Formula Basics -- Chapter 2: Introduction to Array Formulas -- Chapter 3: Math Array Operations -- Chapter 4: Comparative Array Operations and Aggregate Calculations with One or More Conditions -- Chapter 5: Join Array Operations -- Chapter 6: Function Argument Array Operations -- Chapter 7: Array Constants -- Chapter 8: Array Formulas That Deliver More Than One Value -- Chapter 9: A First Look at Array Functions: TRANSPOSE, MODE.MULT, and TREND -- Chapter 10: The Amazing SUMPRODUCT Function (and SUMIFS, Too) -- Chapter 11: Boolean Logic: AND Criteria and OR Criteria -- Chapter 12: When Is an Array Formula Really Needed? -- Chapter 13: Dynamic Ranges with the INDEX and OFFSET Functions -- Chapter 14: Array Formula Efficiency Rules -- Chapter 15: Extracting Data, Based on Criteria -- Chapter 16: The FREQUENCY Array Function -- Chapter 17: Unique Counting Formulas and the Power of the FREQUENCY Function -- Chapter 18: The MMULT Array Function -- Chapter 19: Extracting Unique Lists and Sorting Formulas -- Chapter 20: Conditional Formatting with Array Formulas -- Chapter 21: Data Tables -- Chapter 22: The LINEST Array Function -- Chapter 23: Can You Figure Out How the Huge Array  Formula Works? -- Conclusion -- Index.
330   $aDesigned with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.
606   $aElectronic spreadsheets$xComputer programs
615  0$aElectronic spreadsheets$xComputer programs.
676   $a005.54
700   $aGirvin$b Mike$01656184
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
906   $aBOOK
912   $a9910814971103321
996   $aCtrl+shift+enter$94008901
997   $aUNINA