October 16, 2015
Excel Magic Trick 1169
DESCRIPTION Topics in this video: (00:10) INDEX and MATCH. (00:32) Lookup Left, 1-way vertical range lookup. (04:41) Lookup Low Bid, 1-way horizontal range lookup. (08:27) 2-way lookup to lookup discount rate. (13:14) Lookup Whole Row […]
Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]
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 […]
You must be logged in to post a comment.