View Detailed Profile
Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates

Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates

Download

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

Download

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists

Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT575-578.xls See how to create a

Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data

Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data

Download

Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria

Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria

Download

Excel Magic Trick #127: Count Less Than 70% of Max

Excel Magic Trick #127: Count Less Than 70% of Max

Download

Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010

Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010

Download

Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)

Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)

Download

Excel Magic Trick 434: Extract Completed Records with Formula

Excel Magic Trick 434: Extract Completed Records with Formula

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT431-439.xls See how to create an array

Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array

Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array

Download

Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups

Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups

Download File: https://excelisfun.net/files/EMT1444-1445.xlsx See how to use

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Download