tag:blogger.com,1999:blog-1869924468172210809.post4798315920949257336..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Adding categories to data in Excel - how to save you time laterGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-1869924468172210809.post-43962089954088085172014-05-18T23:52:25.939+01:002014-05-18T23:52:25.939+01:00Agreed!Agreed!adriersā¼https://www.blogger.com/profile/10069659080175040700noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-6587247383362057332013-08-24T11:22:25.130+01:002013-08-24T11:22:25.130+01:00Your title is wrong "Adding categories to dat...Your title is wrong "Adding categories to data in Excel - how to save you time later" it does not tell me how to add categories to data in Excel Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-91378826903205601082012-03-02T20:32:27.808+00:002012-03-02T20:32:27.808+00:00Brian
Thanks Brian. I've used the date groupi...Brian<br /><br />Thanks Brian. I've used the date grouping stuff in pivot tables and it is quite impressive, but one of the restrictions that I find particularly frustrating is that if any item in the date field is not a date, the grouping disappears altogether.<br /><br />This can be a bit of a nightmare when a 12 row pivot table suddenly becomes a 3000 row pivot table.<br /><br />Also, not using the helper column wouldn't really have illustrated the point I was trying to get across - about using this approach to group data rather than have separate columns.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-25204469598875546462012-03-02T19:09:59.799+00:002012-03-02T19:09:59.799+00:00Indeed. If I had a cent for everyone who knows all...Indeed. If I had a cent for everyone who knows all there is to know about Excel, I'd be penniless.<br />So in Pivot Tables check out the flexibility of date data. With the date you can slice/dice by month, quarter, year, etc., etc. So it is usually unnecessary to create a helper column like that with the Month text.<br />Regards<br />BrianBrianhttps://www.blogger.com/profile/06063334745698094480noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-46954386177663826782012-03-02T18:39:14.836+00:002012-03-02T18:39:14.836+00:00Cheers Brian.
We're all still learning!
Glen...Cheers Brian.<br /><br />We're all still learning!<br /><br />GlenGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-46148762003242126492012-03-02T18:32:06.000+00:002012-03-02T18:32:06.000+00:00Instead of the clunky =CHOOSE(MONTH($A2),"Jan...Instead of the clunky =CHOOSE(MONTH($A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") you could use =TEXT(A2,"mmm")<br />Regards<br />BrianBrianhttps://www.blogger.com/profile/06063334745698094480noreply@blogger.com