Excel Is Fun

Excel Magic Trick 1369

DESCRIPTION See two methods to Count Entered Results For Shift & Date Range using COUNTIFS function: 1. Introduction to a well asked question 2. Create Defined Names 3. Create COUNTIF Formula #1, where we have [Read More >>>]

Dueling Excel

Dueling Excel 149

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with [Read More >>>]

Dueling Excel

Dueling Excel 142

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

Dueling Excel

Dueling Excel 128

DESCRIPTION Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF See Mr Excel and excelisfun use two methods to count the occurrences of items in a list: 1. PivotTable 2. Advanced Filter Extract Unique [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 >>>]

Dueling Excel

Dueling Excel 118

DESCRIPTION Formula To Calculate Commissions for Four Scenarios See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for [Read More >>>]

Dueling Excel

Dueling Excel 102

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, [Read More >>>]

Dueling Excel

Dueling Excel 91

Rank Scores, But If Tie Award Highest Rank To The Largest Weight DESCRIPTION See Mr Excel and excelisfun use two methods to rank scores with the heights Weight: 1. See how to use RANK or [Read More >>>]

Dueling Excel

Dueling Excel 86

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, [Read More >>>]