How To: Make an Excel formula for a decimal stem & leaf chart

Make an Excel formula for a decimal stem & leaf chart

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest