Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates. That video is uploaded by ExcelIsFun at 2012-08-24T13:01:36-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [rKDI-kdBsjY]
| Name | Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates |
| Video Uploader | Video From ExcelIsFun |
| Upload Date | This Video Uploaded At 24-08-2012 20:01:36 |
| Video Discription | Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT967.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Concepts: 1. This video is great to learn how to use a formula to extract top 5 numbers (revenues, sales, units or sports scores) and the associated names (Sales Representatives, Employees or Athlete Names) including the situation when there are ties or duplicates in the numbers. 2. What to do when VLOOKUP can't do a lookup for duplicate values or ties and it is not possible to do a concatenated helper column; meaning there are not two lookup values, but instead just one lookup value (number value from LARGE). In this Video: 1. SMALL Function Example: for Excel 2007 or earlier array formula with the functions: LARGE, COUNTIF, IF, ROWS, INDEX, SMALL and ROW. Also see: array operations, comparative operators, join symbol ampersand, and expandable ranges. 2. AGGREGATE Function Example: Excel 2010 or 2013 array formula with the functions: LARGE, COUNTIF, IF, ROWS, INDEX, AGGREGATE and ROW. Also see: array operations, comparative operators, join symbol ampersand, syntax for show nothing or empty cell or null text string and expandable ranges. 3. How Come VLOOKUP will not work 4. Find Hurdle Value for Top 5 using LARGE function 5. Count how many values should be extracted using COUNTIF function, comparative operator and Ampersand (join symbol) rKDI-kdBsjY |
| Category | Education |
| Tags | Excel | 2013 | 2003 | 2007 | 2010 | exceisfun | Mike | Girvin | Highline | Community | College | Slaying | Dragons | Formula | To | Extract | Top | Numbers | Names | Ties | Duplicates | units | sports | scores | Sales | Representatives | Employees | Athlete | VLOOKUP | lookup | not | two | values | functions | LARGE | COUNTIF | IF | ROWS | INDEX | SMALL | AGGREGATE | ROW | array | operations | comparative | operators | join | symbol | ampersand | syntax | empty | cell | null | text | string | expandable | ranges |
