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

Excel Is Fun

Excel Magic Trick 1301

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

Dueling Excel

Dueling Excel 147

DESCRIPTION See Mr Excel and excelisfun Avoid Sheet References From Current Sheet in a formula: 1. View, Arrange Vertically 2. Use Function Argument Dialog Box (Zack Barresse trick) WORKBOOKS

Dueling Excel

Dueling Excel 146

DESCRIPTION Excel Truel: This is a simple Excel task: multiplying, but for a kid, its seems amazing! See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin try to multiply in Excel. WORKBOOKS

Dueling Excel

Dueling Excel 145

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS