Dueling Excel

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

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 Is Fun

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 Is Fun

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 Is Fun

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

Templates

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 Is Fun

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 Is Fun

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

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

Excel Is Fun

Excel Magic Trick 1125

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well [Read More >>>]