Excel Forum



Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics


See how to to create an array formula for a Stem and Leaf Chart for decimal numbers. See the functions: IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW, TEXT. Also see: Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions & Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers





Got a Question? Ask it Here in the Forum.