Excel Is Fun

Excel Magic Trick 1155

August 27, 2015 0

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

Excel Is Fun

Excel Magic Trick 1154

August 24, 2015 0

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

Excel Is Fun

Excel Magic Trick 1153

August 20, 2015 0

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

Dueling Excel

Dueling Excel 036

August 12, 2015 0

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

Dueling Excel

Dueling Excel 033

July 22, 2015 0

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

Excel Is Fun

Excel Magic Trick 1143

July 16, 2015 0

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

Dueling Excel

Dueling Excel 031

July 8, 2015 0

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

Dueling Excel

Dueling Excel 028

June 17, 2015 0

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

Excel Is Fun

Excel Magic Trick 1134

June 15, 2015 0

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

Excel Is Fun

Excel Magic Trick 1132

June 8, 2015 0

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