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
Very easy and useful tip
@DougHExcel
7 ай бұрын
Thanks @t4tumi488, glad it helped!
LIFE SAVER! Thank you! God bless ✨
@DougHExcel
3 ай бұрын
No problem 😊
You just saved me. 🤟🏿
thanks for the tip, very useful
@DougHExcel
7 ай бұрын
Glad it was helpful!
Thanks sir
@DougHExcel
4 ай бұрын
Welcome!
How to create first & last?
But power pivot doesnr allow this.-.
How would I do this if I need group net sales into 13 different buckets?
@DougHExcel
3 ай бұрын
Try Grouping Data with Power Query kzread.info/dash/bejne/qGtmsrRsn5OfgJs.html
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
Ай бұрын
you ever figure this out lol?
I am not getting the option to choose from which and by how many after clicking group
@maarnasrul1717
9 ай бұрын
yes,so i am😅
@iuniversol
8 ай бұрын
Me either. I know this is a short bit dude flew through this.
@angobertineasua8258
8 күн бұрын
Me too