Calculating Age Groups

[@cherylnjy]

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

[@SadikchyaGhimire]

literally did my MBA assignment after browsing 100 of vids, Thanks!

[@excelace]

Love this 🎉

[@kukuTechn_Temdia]

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]

Very pleased to hear that!! 😁

[@caroluss7604]

best short explanation and easy to understand thanksyou

[@excelace]

Glad you found it helpful. 😁

[@lol-pz1ni]

thank you so much for this, honestly being looking for something so clear and easy to do this and now I know :)

[@excelace]

Happy to help! 😁

[@motunrayoibitoye5214]

Thank you so much, just followed your instructions and was able to do it!

[@louisemorgan-taylor8710]

Fantastic! Thank you, it's exactly what I needed 😊

[@excelace]

Very happy to hear that. 😁

[@lynbellibunao4646]

"hope that helps" it did helps me a lot. THANK YOU!

[@homefoodwizard1177]

Thanks for the information

[@maryrace8680]

Very helpful, thank you

[@urnobyss7614]

well done

[@afiffahmi41]

Very helpful

[@washingtonalmeida75]

Brilliant, thank you!

[@alandavison6365]

Could you also colour the rows based on age group?

[@irishdawn8387]

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]

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!

[@navidshafieesabett634]

Thank you. this was so helpful.

[@robysupertrump]

genius, finally true in the vlookup has an application

[@excelace]

I LOVE True since I found a use for it!! You want to check out XLOOKUP......there are 4 options available!! 😁

[@kabirraji7772]

Thank you so much for this

[@excelace]

Very welcome. Xx

[@tm1972]

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]

Either use Filters, or Pivot Tables. Please feel free to e-mail me an example file and I can advise more precisely: [e-mail] Thanks, Traci.

[@afiffahmi41]

@@excelace Hi, can I send you questions through your email too?

[@excelace]

@@afiffahmi41 yes of course.

[@AravindRavi]

Thank you !

[@marinakljakovic-gaspic1586]

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]

Otherwise I am very thankfull for this video!!

[@excelace]

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]

@@excelace Thank you!

[@Kbipin2020]

thanks you

[@Alexbordo66]

op thanks

[@lesegomotselenyane1706]

Thank you so much 😊🙏

[@Bjot26]

Not able to do it....

[@excelace]

If you can you give me more details as to what issues you're having, I can try to help?

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

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]

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

Could you also colour the rows based on age group?

[@excelace]

@alandavison6365 Yes, of course, using Conditional Formatting (Home ribbon).

[@alandavison6365]

@@excelace have tried to do this but can’t seem to get it to work

[@excelace]

@@alandavison6365 feel free to send me your file and I can have a look for you: [e-mail]