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

[@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!

[@excelisfun]

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

[@excelisfun]

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

[@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

[@stephenlambert3604]

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

[@MartinGarcia007]

copy the function 4 us to copy it :$