Dueling Excel

Dueling Excel 142

May 17, 2017 0

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

February 8, 2017 0

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

Excel Is Fun

Excel Magic Trick 1246

November 10, 2016 0

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

Dueling Excel

Dueling Excel 118

November 9, 2016 0

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

Dueling Excel

Dueling Excel 102

September 14, 2016 0

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

Dueling Excel

Dueling Excel 91

August 5, 2016 0

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

Dueling Excel

Dueling Excel 86

July 13, 2016 0

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

Dueling Excel

Dueling Excel 84

June 29, 2016 0

Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit DESCRIPTION See Mr Excel and excelisfun use two methods to count calls every 15 minutes: 1. a PivotTable and a Helper Column using […]

Dueling Excel

Dueling Excel 77

May 11, 2016 0

Top Two Customers In Each Industry PivotTable or Sort Filter Formula DESCRIPTION See Mr Excel and excelisfun extract Top Two Customers In Each Industry using a Pivot Table or Sort Filter & Formula with COUNTIF […]

Dueling Excel

Dueling Excel 59

January 13, 2016 0

Custom Lists, Defined Names, PivotTable & COUNTIF Function DESCRIPTION See Mr Excel and excelisfun create Custom Lists, Defined Names, a PivotTable & the COUNTIF Function to create a sorted Frequency Table. WORKBOOKS