Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Grouping Dates

I have a spreadsheet of incidents, and am trying to perform trends on this.
The spreadsheet has Incident Details with dates raised.

I want to do a deliquency report which shows incidents overdue by teams,
based on dates, ie 0-10 days overdue, 11-30 days etc.

The sheet has a couple of thousand records, and I do not really want to
manually group all these, so that I can then do a Pivot based on this.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PIVOT TABLE - GROUPING DATES FARAZ QURESHI Excel Discussion (Misc queries) 1 April 30th 08 01:26 PM
Grouping Dates in a Pivot Table mike Excel Worksheet Functions 1 May 9th 07 12:43 PM
Grouping DATES in a pivot tables Peter Excel Discussion (Misc queries) 1 April 17th 07 09:04 PM
Grouping DAtes in Pivot Tables berby65 Excel Discussion (Misc queries) 4 December 1st 06 11:52 PM
Grouping Dates in Pivot tables Andy M Excel Discussion (Misc queries) 8 March 26th 05 05:01 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"