Excel Is Fun

Excel Magic Trick 1310

August 3, 2017 0

DESCRIPTION Calculate Minimum Value Greater Than Zero. See the functions: SMALL, COUNTIFS and AGGREGATE (LARGE). WORKBOOKS

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 1308

July 27, 2017 0

DESCRIPTION Learn how to Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN (New Excel 2016 Function). WORKBOOKS

Excel Is Fun

Excel Magic Trick 1307

July 24, 2017 0

DESCRIPTION Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function: (00:13) Problem Set Up (01:25) Look at Logical Formula using AND and […]

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: […]

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 […]

Excel Is Fun

Excel Magic Trick 1302

June 29, 2017 0

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel […]

Excel Is Fun

Excel Magic Trick 1301

June 26, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between […]