Excel Is Fun

Excel Magic Trick 1155

IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1154

Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) DESCRIPTION See how to Unique Count For Name & Date & Criteria From 3rd Column: (00:08) Problem Setup (00:50) Array Formula. Learn about IF [Read More >>>]

Excel Is Fun

Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]

Dueling Excel

Dueling Excel 036

VLOOKUP w Approximate Match & Unsorted Table DESCRIPTION See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his [Read More >>>]

Dueling Excel

Dueling Excel 033

First Monday For Reporting Period DESCRIPTION See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday [Read More >>>]

Excel Is Fun

Excel Magic Trick 1143

Extract Content From Non-Empty Cells: Filter or Array Formula? DESCRIPTION See how to use Filter and Array Formulas to Extract Content From Non-Empty Cells: (00:39) Filter, Copy, Paste (01:26) Excel 2010 or later formula with [Read More >>>]

Dueling Excel

Dueling Excel 031

Word Wrap Problem: Formula or VBA solution? DESCRIPTION excelisfun does 15 tricks in one to go from a bad data set to a good data set: 1) GoTo Special Blanks 2) Ctrl + Enter to [Read More >>>]

Dueling Excel

Dueling Excel 028

Find Earliest Date From List Of Dates Given 2 Criteria DESCRIPTION See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses [Read More >>>]

Excel Is Fun

Excel Magic Trick 1134

IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples DESCRIPTION See how to assign product and sales categories using various methods: Overview (00:44) Overview (01:30) IF and Hard Coded Values: Violates Excel’s [Read More >>>]

Excel Is Fun

Excel Magic Trick 1132

Extract and Sort Numbers Greater Than Zero with Formula DESCRIPTION See how to Extract and Sort Numbers Greater Than Zero With Formula using COUNTIF, LARGE, and IF functions. WORKBOOKS