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

Download Files:
people.highlin...
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

[@excelisfun]

Try this video:
Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

[@stephenlambert3604]

When I do it the other way the other way it has loads of #NAME things. HELP!! PLZ!!

[@excelisfun]

Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions
Or
Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers

[@Trybanpherto]

A heartfelt thanks for all the work you put into these videos. My understanding, and my productivity with Excel, has improved significantly since finding your channel via the Mr Excel website and podcast.
Thanks!

[@excelisfun]

I am glad that the videos help!

[@vanessamacri5514]

i keep getting the #value! error when i drag down so that the formula applies to everything. do you know why this is?

[@mryip06]

+Vanessa Macri
Press Ctrl Shift Enter for the first cell before you drag down.

[@vanessamacri5514]

Thank you for answering over a year later

[@mohamadhussein8333]

rude bitch lol

[@MartinGarcia007]

copy the function 4 us to copy it :$