View Detailed Profile
Excel Magic Trick #237: ROUND to Digit or Multiple

Excel Magic Trick #237: ROUND to Digit or Multiple

Download

Excel Magic Trick #238: Round Times To 5 Minutes

Excel Magic Trick #238: Round Times To 5 Minutes

Download

Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter

Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter

Download

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Download

Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More

Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More

Start File and Finished File: https://excelisfun.net/files/EMT1377.xlsx See how to create a formula to list incomplete / missing ...

Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions

Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions

What To Do When No MROUND. IncongruentBalance sends in a

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Download

Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)

Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)

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 #200: Excel Table Formula Nomenclature

Excel Magic Trick #200: Excel Table Formula Nomenclature

Download

Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%

Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%

Download

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 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Download