Jump to content
House Price Crash Forum

Archived

This topic is now archived and is closed to further replies.

StuG III

Any Excel Nerds Here?

Recommended Posts

Need some help with excel -

I have a pivot table with dates in the left column and a simple count in the right. I need to group the dates into weeks and show the total count for each week.

This was working fine till just now, when all of a sudden excel decided to stop recognising the grouped dates as dates and therefore wont sort them properly. If I ungroup them then excel recognises them as dates again.

WTF?

How do I fix this? Apart from Thorium?

Share this post


Link to post
Share on other sites

Check that the column with the dates in is formatted for dates? It could be something as simple as that.

Like I said, its fine with them as long as they arent grouped as days. Grouped by months and days is fine. Ungrouped is fine. All recognised as dates as interchangeable with different date formats and number format. But suddenly it doesnt like it if the days are grouped. graaaaaaaaah!

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

  • The Prime Minister stated that there were three Brexit options available to the UK:   212 members have voted

    1. 1. Which of the Prime Minister's options would you choose?


      • Leave with the negotiated deal
      • Remain
      • Leave with no deal

    Please sign in or register to vote in this poll. View topic


×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.