Contents Notes |
"A book about building efficient formulas, advanced formulas, and array formulas for data analysis and calculating problems"--Cover. Formula basics -- Introduction to array formulas -- Math array operations -- Comparative array operations and aggregate calculations with one or more conditions -- Join array operations -- Function argument array operations -- Array constants -- Array formulas that deliver more than one value -- A first look at array functions: TRANSPOSE, MODE. MULT, and TREND -- The amazing SUMPRODUCT function (and SUMIFS, too) -- Boolean logic: AND criteria and OR criteria -- When is an array formula really needed? -- Dynamic ranges with the INDEX and OFFSET functions -- Array formula efficiency rules -- Extracting data, based on criteria -- The FREQUENCY array function -- Unique counting formulas and the power of the FREQUENCY function -- The MMULT array function -- Extracting unique lists and sorting formulas -- Conditional formatting with array formulas -- Data tables -- The LINEST array function -- Can you figure out how the huge array formula works? |