Excel Is Fun

Excel Magic Trick 1309

July 31, 2017 0

DESCRIPTION Learn how to create an array formula to display a unique list in a single cell. This formula comes from Bill Szysz at YouTube. See the functions: MATCH, ROW, IF and the new Excel […]

Excel Is Fun

Excel Magic Trick 1306

July 20, 2017 0

DESCRIPTION Learn how to create a formula that simulates a relationship between two tables (like a VLOOKUP Helper Column) to create a Regional Report. See array formula where we see VLOOKUP function and Exact Match […]

Excel Is Fun

Excel Magic Trick 1305

July 17, 2017 0

DESCRIPTION Learn how to perform multiple two-way lookups for a cross tabulated table to get multiple sales numbers and then add them using an array formula. Learn how to get INDEX function to deliver an […]

Excel Is Fun

Excel Magic Trick 1304

July 15, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. Learn how to get INDEX function to deliver an array of items using the formula element: […]

Dueling Excel

Dueling Excel 150

July 12, 2017 0

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside […]

Dueling Excel

Dueling Excel 149

July 5, 2017 0

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

Excel Is Fun

Excel Magic Trick 1303

July 3, 2017 0

DESCRIPTION Learn how to to create three different formulas to calculate minimum value greater than zero: (00:13) Introduction (01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4)) (03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1) (04:53) Excel 2016 or […]

Dueling Excel

Dueling Excel 143

May 24, 2017 0

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]

Dueling Excel

Dueling Excel 142

May 17, 2017 0

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 32

April 21, 2017 0

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]