Channel: ExcelIsFun

Category: Education

Tags: formulas and functionsrow and indirect functionshighline collegemike girvinemtgrading subtract two lowestgrading top 3 valuesexcel is funexcel magicsmall functionsoffice 365excel functionsexcel funsubtract two lowestbyrow functionexcel magic trick 1775excellarge functionemt 1775add to 3sum top 3sequence functionmicrosoft 365 excelsum functionexcel 365excel formulaslambda functionexcelisfun

Description: Download Excel File: excelisfun.net/files/EMT1775.xlsx Learn 3 formula methods to add the top three values. Learn how to. 1. (00:00) Introduction 2. (00:12) Look at the issues that make this problem difficult 3. (00:59) 1st solution: SUM, LARGE and SEQUENCE solution 4. (01:10) 1st for if you don’t have Microsoft 365 Excel 5. (02:49) 2nd solution SUM and SMALL functions solution 6. (03:52) BYROW and LAMBDA functions solution to spill formula. Solution only works in Microsoft 365 Excel (Beta as of Feb 2022). 7. (05:44) Change input to change Top 3 to Top 4 8. (06:01) Summary 9. (06:11) Closing and Video Links