Dueling Excel

Dueling Excel 84

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

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

Dueling Excel

Dueling Excel 029

Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP [Read More >>>]

Excel Is Fun

Excel Magic Trick 1133

Aging Accounts Receivable Reports: PivotTable & Unique Identifier DESCRIPTION See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: (01:49) Days Late Helper Column Formula: [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