Overview: Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT490- Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks90.xls Finished File: ...

Photo Gallery

Excel Magic Trick 493: Repeat a List of Names 7 times
Excel Magic Trick 493  Repeat a List of Names 7 times
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?
Excel Magic Trick 1165: Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions
Excel Magic Trick 1161:   F4 Key To Repeat Last Action
Excel Magic Trick #90: Consolidation
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
Excel Magic Trick 943: Conditional Format First Three & Conditional Format After 3rd Occurrence
Excel Magic Trick #197: Grade Book with Weights