Dueling Excel

Dueling Excel 144

DESCRIPTION See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin have mirror fun in Excel. Copy stuff like it was a mirror with: Relative Cell Reference Paste Special Picture Link View New [Read More >>>]

Excel Is Fun

Excel Magic Trick 1300

DESCRIPTION Learn how to list all modes in single cell with TEXTJOIN & MODE.MULT. learn about the three different mode functions: MODE, MODE.SNGL and MODE.MULT. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1299

DESCRIPTION Learn how to: create Automatic Calendar Table in Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

Dueling Excel

Dueling Excel 143

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

Excel Is Fun

Excel Magic Trick 1298

DESCRIPTION Learn how to Group By Date in Power Pivot Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1297

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with a Join Array Operation to create the OR Criteria Array that goes into the criteria argument& then the [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

Excel Is Fun

Excel Magic Trick 1296

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with OR Criteria & SUMPRODUCT function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1295

DESCRIPTION Learn how to create random transaction description codes for products by randomly looking up a row from a product lookup table with the INDEX and RANDBETWEEN functions and then join them with a dash [Read More >>>]

Dueling Excel

Dueling Excel 141

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the [Read More >>>]