Excel Is Fun

Excel Magic Trick 1325

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]

Excel Is Fun

Excel Magic Trick 1322

DESCRIPTION See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: (00:16) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1318

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create report and Chart for How Many Unique Visitors To Site Each Day with Two Methods: (00:13) Introduction (01:01) Excel 2016 Data Model [Read More >>>]

Excel Is Fun

Excel Magic Trick 1313

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1312

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count [Read More >>>]

Excel Is Fun

Excel Magic Trick 1311

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See [Read More >>>]

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 1302

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

Dueling Excel

Dueling Excel 148

DESCRIPTION See Mr Excel and excelisfun create a Formula To Deliver TRUE When 3 Out 4 Tests Are Met 1. Boolean Formula with 4 Logical Tests (See Formula Evaluator) 2. SUM function with 4 Logical [Read More >>>]

Dueling Excel

Dueling Excel 142

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