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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…