Calculating Age Groups

  Рет қаралды 134,984

Excel Ace

Excel Ace

Күн бұрын

Пікірлер: 47
@SadikchyaGhimire
@SadikchyaGhimire 9 ай бұрын
literally did my MBA assignment after browsing 100 of vids, Thanks!
@excelace
@excelace 9 ай бұрын
Love this 🎉
@cherylnjy
@cherylnjy 2 жыл бұрын
omg thank you so so much for this. I have been watching so many videos and none of them worked out until I found yours! THANK YOU
@kukuTechn_Temdia
@kukuTechn_Temdia 3 ай бұрын
It's literally helpful and helped me to analyze my MSc survey questionnaire. Thanks for making such a brilliant video. and keep up the good job
@excelace
@excelace 3 ай бұрын
Very pleased to hear that!! 😁
@caroluss7604
@caroluss7604 2 жыл бұрын
best short explanation and easy to understand thanksyou
@excelace
@excelace 2 жыл бұрын
Glad you found it helpful. 😁
@lol-pz1ni
@lol-pz1ni 3 жыл бұрын
thank you so much for this, honestly being looking for something so clear and easy to do this and now I know :)
@excelace
@excelace 3 жыл бұрын
Happy to help! 😁
@louisemorgan-taylor8710
@louisemorgan-taylor8710 2 ай бұрын
Fantastic! Thank you, it's exactly what I needed 😊
@excelace
@excelace 2 ай бұрын
Very happy to hear that. 😁
@alandavison6365
@alandavison6365 5 ай бұрын
Could you also colour the rows based on age group?
@lynbellibunao4646
@lynbellibunao4646 2 жыл бұрын
"hope that helps" it did helps me a lot. THANK YOU!
@motunrayoibitoye5214
@motunrayoibitoye5214 3 жыл бұрын
Thank you so much, just followed your instructions and was able to do it!
@irishdawn8387
@irishdawn8387 2 жыл бұрын
this is great, um is there a way I can calcuate data for a specific group like, let's say how many people who are young adults in a colum between ages 13-19 ?
@JenniferKYoung
@JenniferKYoung 3 ай бұрын
Yes! I am wondering the same thing. What formula could then count the # of "under 18" or "18-21" How do I do this?! please and thank you!
@tm1972
@tm1972 3 жыл бұрын
If I have a list of Male and Female with ages, how best to separate them to form columns of age groups for each?
@excelace
@excelace 3 жыл бұрын
Either use Filters, or Pivot Tables. Please feel free to e-mail me an example file and I can advise more precisely: info@excelace.co.uk Thanks, Traci.
@afiffahmi41
@afiffahmi41 2 жыл бұрын
@@excelace Hi, can I send you questions through your email too?
@excelace
@excelace 2 жыл бұрын
@@afiffahmi41 yes of course.
@robysupertrump
@robysupertrump 2 жыл бұрын
genius, finally true in the vlookup has an application
@excelace
@excelace 2 жыл бұрын
I LOVE True since I found a use for it!! You want to check out XLOOKUP......there are 4 options available!! 😁
@washingtonalmeida75
@washingtonalmeida75 Жыл бұрын
Brilliant, thank you!
@marinakljakovic-gaspic1586
@marinakljakovic-gaspic1586 2 жыл бұрын
I don't get it... every age group starts with for example with 50, and previous group ends with 50 EXCEP 60-70 and 71-80. Why 71??
@marinakljakovic-gaspic1586
@marinakljakovic-gaspic1586 2 жыл бұрын
Otherwise I am very thankfull for this video!!
@excelace
@excelace 2 жыл бұрын
I think that is just a typo in the Age Group column. The important part is the Age column though, as that is used for the calculation.
@marinakljakovic-gaspic1586
@marinakljakovic-gaspic1586 2 жыл бұрын
@@excelace Thank you!
@navidshafieesabett634
@navidshafieesabett634 2 жыл бұрын
Thank you. this was so helpful.
@maryrace8680
@maryrace8680 2 жыл бұрын
Very helpful, thank you
@homefoodwizard1177
@homefoodwizard1177 3 жыл бұрын
Thanks for the information
@urnobyss7614
@urnobyss7614 3 жыл бұрын
well done
@afiffahmi41
@afiffahmi41 2 жыл бұрын
Very helpful
@kabirraji7772
@kabirraji7772 2 жыл бұрын
Thank you so much for this
@excelace
@excelace 2 жыл бұрын
Very welcome. Xx
@AravindRavi
@AravindRavi Жыл бұрын
Thank you !
@Bjot26
@Bjot26 3 ай бұрын
Not able to do it....
@excelace
@excelace 3 ай бұрын
If you can you give me more details as to what issues you're having, I can try to help?
@Kbipin2020
@Kbipin2020 24 күн бұрын
thanks you
@lesegomotselenyane1706
@lesegomotselenyane1706 4 ай бұрын
Thank you so much 😊🙏
@Alexbordo66
@Alexbordo66 11 ай бұрын
op thanks
@obvioushieidude7668
@obvioushieidude7668 Жыл бұрын
30 year olds are NOT in the same age group as 50 year olds! 50 year olds are old enough to have 30 year old children! There is NO way they are in same age group! People who are in their early 30s are in the same age group as people in their mid-late 20s! Most demographics group people who are 25-34 or 26-35 together! What the heck was going on in your head when you made this spreadsheet?
@excelace
@excelace Жыл бұрын
Wow......many thanks for spending so much time to scrutinise the detail of the range used in this video, I'm very pleased that you watched it so thoroughly. The intention for this video was purely to demonstrate the Excel Formula and Functionality........the ranges used were irrelevant really.
@obvioushieidude7668
@obvioushieidude7668 Жыл бұрын
@@excelace The range makes no logical sense. It sticks out like a sore thumb. No one in the right mind groups 30 year olds with 50 year olds.
@alandavison6365
@alandavison6365 5 ай бұрын
Could you also colour the rows based on age group?
@excelace
@excelace 5 ай бұрын
@alandavison6365 Yes, of course, using Conditional Formatting (Home ribbon).
@alandavison6365
@alandavison6365 5 ай бұрын
@@excelace have tried to do this but can’t seem to get it to work
@excelace
@excelace 5 ай бұрын
@@alandavison6365 feel free to send me your file and I can have a look for you: info@excelace.co.uk
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
How to Calculate Age Using a Date of Birth in Excel (The Easy Way)
3:09
Excel Tutorials by EasyClick Academy
Рет қаралды 2,1 МЛН
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 594 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
How to Create Age Groups in Excel
3:14
Awesome Emmanuel
Рет қаралды 1,6 М.
Use an Excel Pivot Table to Group Data by Age Bracket
8:13
Danny Rocks
Рет қаралды 386 М.
Make a Search Bar in Excel to Find Anything!
10:35
Kenji Explains
Рет қаралды 421 М.
Math Olympiad l A Beautiful Exponential Problem l VIJAY Maths
10:30
How to group a pivot table by age range
2:48
Exceljet
Рет қаралды 163 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 384 М.