Quickly Group List by Age Ranges - Excel

To quickly group a list by age ranges in Microsoft Excel you may think of creating an extra helper column and then entering the group ranges in the respective cells and then doing some kind of outline group. Don't do that! Instead use a Pivot Table to help group records. Here's an Excel #shorts video to show you how.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Пікірлер: 19

  • @t4tumi488
    @t4tumi4887 ай бұрын

    Very easy and useful tip

  • @DougHExcel

    @DougHExcel

    7 ай бұрын

    Thanks @t4tumi488, glad it helped!

  • @khanyingobese1007
    @khanyingobese10073 ай бұрын

    LIFE SAVER! Thank you! God bless ✨

  • @DougHExcel

    @DougHExcel

    3 ай бұрын

    No problem 😊

  • @bendavis9951
    @bendavis99515 ай бұрын

    You just saved me. 🤟🏿

  • @charulohia8477
    @charulohia84777 ай бұрын

    thanks for the tip, very useful

  • @DougHExcel

    @DougHExcel

    7 ай бұрын

    Glad it was helpful!

  • @rsssingh3172
    @rsssingh31724 ай бұрын

    Thanks sir

  • @DougHExcel

    @DougHExcel

    4 ай бұрын

    Welcome!

  • @md.golamsaklain2317
    @md.golamsaklain231711 ай бұрын

    How to create first & last?

  • @jeffkoh9905
    @jeffkoh99055 ай бұрын

    But power pivot doesnr allow this.-.

  • @LisaLM-sp1xn
    @LisaLM-sp1xn3 ай бұрын

    How would I do this if I need group net sales into 13 different buckets?

  • @DougHExcel

    @DougHExcel

    3 ай бұрын

    Try Grouping Data with Power Query kzread.info/dash/bejne/qGtmsrRsn5OfgJs.html

  • @jitender60
    @jitender605 ай бұрын

    If I want first group is 20-25 but second grup between 25-40 and last one is 40-end age how please solve the problem?

  • @MatthewBohli-rm5xs

    @MatthewBohli-rm5xs

    Ай бұрын

    you ever figure this out lol?

  • @Thefaysl
    @Thefaysl9 ай бұрын

    I am not getting the option to choose from which and by how many after clicking group

  • @maarnasrul1717

    @maarnasrul1717

    9 ай бұрын

    yes,so i am😅

  • @iuniversol

    @iuniversol

    8 ай бұрын

    Me either. I know this is a short bit dude flew through this.

  • @angobertineasua8258

    @angobertineasua8258

    8 күн бұрын

    Me too

Келесі