Not often I ask an Excel Question

  cherria 16:17 13 Aug 04
Locked

I'm sure I've done this before but just can't remember how.

I've created a pivot table where I have a date field along one of the table axis.

So I end up with hundreds of entries one for each date.

I thought there was a way to automatically group the dates by year or by year and month, but I can't find it.

Any ideas?

  VoG II 16:30 13 Aug 04

I don't use pivot tables so this may be totally wrong! This is for Excel 2003.

Click on a date. On the Pivot Table toolbar click on PivotTable, then on Group and Show Detail, then on Group.

  cherria 16:45 13 Aug 04

Vog

Thanks, you are right and that was what I was doing, I just found some blank rown in my data table that were stopping the grouping from working.

Sorted now.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…