Excel Is Fun

Excel Magic Trick 1309

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1308

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

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1306

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 [Read More >>>]

WORKBOOKS & WORKSHEETS

Organising Workbooks

Excel workbooks can accumulate very quickly and you can very easily start to lose your way so it is always good practice to be organised from the start. In this article we will provide a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1305

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 [Read More >>>]

Formulas & Functions

Display Formulas

Display Formulas You Can toggle between Excel’s normal display which shows the results of the formulas in the spreadsheet and a display mode that shows the actual formulas. The keyboard shortcut is Ctrl + tilde [Read More >>>]

Excel Is Fun

Excel Magic Trick 1304

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: [Read More >>>]

Dueling Excel

Dueling Excel 150

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 [Read More >>>]

Dueling Excel

Dueling Excel 149

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 [Read More >>>]