### Excel Magic Trick 1324

DESCRIPTION See how to extract records with a formula: (00:17) Problem Introduction (01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. [Read More >>>]

### 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 126

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns [Read More >>>]

### Excel Magic Trick 1259

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP [Read More >>>]

### Excel Magic Trick 1250

DESCRIPTION Add Times to Get Total Minutes & Seconds From Downloaded Music Data Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, [Read More >>>]

### Excel Magic Trick 1246

DESCRIPTION Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT Learn how to create EXACT & SUMPRODUCT functions array formula to count with Case Sensitive Criteria in Excel: (00:09) Intro to topic and look back to [Read More >>>]

### Staff Attendance Template 2016

OVERVIEW The Staff Attendance Template 2016 is designed to help monitor staff attendance, sickness, holidays etc. The template is very dynamic allowing you to The template can monitor up to 1000 staff names Modify Leave [Read More >>>]

### Excel Magic Trick 1229

DESCRIPTION Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color Learn how to Extract Items From List 2 that are NOT in List 1 by using Conditional Format Unique Values, [Read More >>>]

### Excel Magic Trick 1226

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) [Read More >>>]

### Dueling Excel 005

DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting [Read More >>>]