Dueling Excel

Dueling Excel 77

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 [Read More >>>]

Dueling Excel

Dueling Excel 017

DESCRIPTION See Mr Excel and excelisfun Create 5 formulas to count times greater than five minutes. Excel functions COUNTIF and TIME. Different syntaxes for the criteria argument in the COUNTIF function WORKBOOKS

Dueling Excel

Dueling Excel 015

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create [Read More >>>]

Dueling Excel

Dueling Excel 013

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new [Read More >>>]

Dueling Excel

Dueling Excel 003

DESCRIPTION See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and criteria syntax Count with criteria conditions. Use [Read More >>>]

Dueling Excel

Dueling Excel 59

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

Dueling Excel

Dueling Excel 58

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales [Read More >>>]

Excel Is Fun

Excel Magic Trick 1163

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine [Read More >>>]

Excel Is Fun

Excel Magic Trick 1152

Formula or Power Query: Cost Report When Product IDs Don’t Match DESCRIPTION See how to create Total Cost Report when Product IDs in transaction table do NOT match Product IDs in Lookup Table: (00:08) Set [Read More >>>]