Excel Forum
Similar Content
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Combine Multiple Chart Types in Excel to Make Powerful Charts
Tutorial: In this tutorial I am going to show you how to combine multiple chart types to create a si...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers


See how to to create an array formula for a Stem and Leaf Chart for numbers that have more than two digits. See the functions: IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL, ROW and the ampersand with two doule quotes (blank) to convert a number to a number as text.
Also see: Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions





Got a Question? Ask it Here in the Forum.