Excel Forum



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.