Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows!
Download
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Download
Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)
Download
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
... https://www.youtube.com/playlist?list=PLrRPvpgDmw0kjL4875H36yNhWBb0f-nci
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
Download
Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
Download
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Related Videos: Excel
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Download
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Download
Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
Download
Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)
Download
Excel Magic Trick 1309: Extract Unique List and List in Single Cell: TEXTJOIN Array Formula
Download
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel If statement