DESCRIPTION See how to calculate the Average Number of Days Between Order Date & Ship Date with three different methods: (00:10) Introduction (00:25) Helper Column Method & AVERAGE Function (02:22) Array Formula #1: AVERAGE Function [Read More >>>]
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 [Read More >>>]
Lookup & Return Last 5 Numbers in a List DESCRIPTION See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable [Read More >>>]
Be the first to comment
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.