Not often I ask an Excel Question

  cherria 16:17 13 Aug 2004
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 2004

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 2004

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.

Elsewhere on IDG sites

OnePlus 5T review

How to draw a mandala

iPhone X review

Les meilleures enceintes Bluetooth à moins de 150 euros