DESCRIPTION Tom would like to do a VLOOKUP to pull all employees for a given department. While VLOOKUP can not return multiple results, Bill and Mike come up with formulas to simulate the request. WORKBOOKS
DESCRIPTION See how to: (00:32) Explain Data and how we will transform it (01:35) Import Excel Table (01:58) Remove unwanted columns (02:10) Split Columns to remove unwanted Product ID data (02:54) Remove column after split [Read More >>>]
DESCRIPTION See how to use Excel Spreadsheet Formulas to rank profits and profits per unit for both All The Products and Products Within Manufacturer. Also see throughout the video various ways to copy a formula [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.