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...
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 Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...



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.