Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Topics for this video: 1)Learn about the basics of array formulas 2)Entering array formulas with Ctrl + Shift + Enter 3)Array syntax 4)Operations on ranges and arrays instead ...

27,597 views

Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Topics for this video: 1)Learn about the basics of SUMPRODUCT 2)The SUMPRODUCT function multiplies arrays of the same size and then adds the products 3)See how to get SUMPRODU...

17,323 views

Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See how to use the array functions: 1)TRANSPOSE 2)FREQUENCY This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn...

9,744 views

Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm If an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead of a single value....

11,717 views

Learn about 7 functions that can handle array sytax and do not require Ctrl + shift + Enter: OR, SMALL, LARGE, LOOKUP, VLOOKUP, INDEX, MATCH functions.

3,643 views

We will try to answer the questions: 1.What is the Difference Between Array and Range? 2.What is an Array Formula? 3.When Do I Have To Use Ctrl + Shift + Enter? Advanced Excel Array Formula Topics

11,430 views

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. See an INDEX and...

48,164 views

Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, SMALL. Return Mul...

17,539 views

Duplicate Lookup or Lookup 1 value, return many for a row Part 3. See a formula that looks up one value and returns multiple items. One To Many Relationship. See an array formula that uses the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL and ROW...

19,391 views

Aladin at the Mr Excel Message Board has great advice about the robustness of formulas. Learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component, then see an array formula that u...

8,523 views

See a formula that can lookup and return all the student names based on the blanks in a different column using the functions COUNTIF, IF, ROWS, INDEX, SMALL, ROW and an array formula. Also see: Excel Magic Trick 359: Part 2: Return Multiple Item...

13,890 views

See a formula that can lookup and return all the class periods based on the blanks in a different row using the functions COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL, COLUMN, and Concatenating (joining) two columns and an array formula. Also see: Exc...

6,483 views

See how to: 1)Extract a unique list of records with a formula and display in a column using the functions IF, ROWS, INDEX, SMALL, FREQUENCY, MATCH, ROW, SUMPRODUCT and COUNTIF. 2)Extract a unique list of numbers only with a formula and display i...

21,460 views

Topics about FREQUENCY array function is this video: 1. Basics of FREQUENCY function -- see all aspects of how this function works (00:34 mins) 2. Create a Vertical Frequency Distribution ( 00:34 mins) 3. Create a Horizontal Frequency Distribution...

11,482 views

See how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel See how to calculate the Total Sales (given rows of input data) ...

66,516 views

See how to use the Array function TRANSPOSE to transpose a table, switching rows and columns to columns and rows. In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduc...

49,552 views

See how to create array formula that will calculate the Expected Return for Stocks. See how to calculate individual stock return and standard deviation given different assumed states of the future economy. See how to use probability and assu...

28,770 views

See how to create array formula for finding the largest improvement in sales from one year to the next. The formula MAX(D5:D9-C5:C9) will show you the biggest improvement Remember to enter array formula with Ctrl + Shift + Enter In this ser...

11,526 views

See how to create array formula for adding the 3 largest or smallest values in a data set. This is a great trick for scoring the Maximum Time Aloft Boomerang event. Array Formulas: Add the 3 highest values Remember to enter array formula with ...

15,869 views

Create an array formula for Bayes' Theorem in Statistics. See the Root (Prior) probability, Conditional Probability, Joint Probability and Posterior Probability. In this series see how to create array formulas in Excel. Array formulas can take ...

15,437 views

See how to create array formulas for Summing and Counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions. See how to create a dynamic table and Chart bases on a c...

26,153 views

See 4 methods for converting TRUE and FALSE to 1 and 0 (zero) using double negative, multiply by one, add zero, and divide by one: --TRUE, TRUE*1, TRUE+0, TRUE/1. See the SUMPRODUCT function and learn about the Order Of Precedents that Excel follo...

9,164 views

See how to use the Array FREQUNCY function correctly. See how to use the FREQUNCY function to counts occurrences in categories. Then use the frequencies to build Frequency Distributions and Histograms. In this series see how to create array for...

28,504 views

See how to create array formula that counts all the characters in a range of cells The formula SUM(LEN(B26:C46)) counts all the characters in a range of cells. Don't forget Ctrl + Shift + Enter In this series see how to create array formulas...

8,896 views

See how to create an array constant from values in cells. This is an amazing trick that can save tons of time when you want your array stored in memory. In this series see how to create array formulas in Excel. Array formulas can take complex s...

7,966 views

See how to create array formulas with the ROW & COLUMN functions in order to create consecutive Integers. Also see how to use the INDIRECT and ROW function together to create permanent consecutive Integers. In this series see how to create a...

19,914 views

See how to use the array function MMULT to multiple Matrices in Matrix Algebra. This is an array function that requires the Ctrl + Shift + Enter trick. In this series see how to create array formulas in Excel. Array formulas can take complex se...

28,890 views

Do Multiple Regression and Linear Algebra with the Array LINEST function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra. Also see how to create a Scatter diagram with a Linear Trend Line.

27,792 views

See how to create array formulas for individual stock return and standard deviation given different assumed states of the future economy. See how to use probability, stock weights and assumed stock returns to calculate individual stock return a...

16,740 views

See how to create array formulas for Portfolio Return & Standard Deviation. See how to calculate individual stock return and standard deviation given different assumed states of the future economy. See how to use probability, stock weights and ...

13,705 views

See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to do this given different assumed states of the future economy. See how to use probability, stock weights an...

24,886 views

See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to calculate individual stock return and standard deviation given different assumed states of the future economy...

16,893 views

Learn how to build Logical Formulas for counting with criteria or Conditional Formatting so that the comparison is between Text and Text or Number and Number. Text to Number comparisons do not yield matches such as 2003 and "2003". Learn how to co...

6,298 views

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm See better formula from Aladin at Mr Excel Message Board for extracting top three customer names from data set without the use of an extra column or helper cells: Mr Excel & excelis...

4,039 views

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Multiple Two Way Lookup Adding using INDIRECT, ADDRESS and ARRAY MATCH Function as well as SUMPRODUCT, SUM and N functions 2. Amazing trick from circlechicken at Mr Excel Messa...

6,721 views

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Use Data Validation and 2010 Excel array formula to Extract Records With Or Criteria to create a Manager Sales Rep Report. See the functions IFERROR, INDEX, AGGREGATE, ROW and ROWS

2,818 views

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Use Data Validation and 2010 Excel array formula to Extract Records With OR & AND Criteria to create a Manager Sales Rep Report. See the functions IFERROR, INDEX, AGGREGATE, ROW...

2,518 views

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to take a step by step approach to creating your own array formulas: 1) First: Create calculation long hand 2) Second: Notice Pattern of long-hand formulas and concoct ...

3,245 views