Dueling Excel

Dueling Excel 61

Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 30

DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for creating labels. 4. Extract First Name formula using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1099

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps. (00:08) Setup of problem (00:46) Excel Table Feature to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1096

DESCRIPTION See how to extract date from middle of text string with a formula that uses SUBSTITUTE, SEARCH and MID functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1093

DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, SEARCH and LEFT WORKBOOKS