| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables, problem with grouping the date column
Hi,
I have a column for payment due dates on my Excel table (Office 2003 - Windows XP Pro - SP2) which I would like to group by months with a pivot table, however some of the dates in the column are not available exactly so it says "not available" in the corresponding cell. I konw that "blank cells" and "non date format cells" are not allowed for grouping. Is there any other way of adding these "not available" text to be included in the grouped columns by month? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping data in pivot tables | Excel Discussion (Misc queries) | |||
| Column Resizing and Pivot Tables | Excel Discussion (Misc queries) | |||
| Grouping Dates in Pivot tables | Excel Discussion (Misc queries) | |||
| Pivot table-date grouping | Excel Discussion (Misc queries) | |||
| How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) | |||
Threaded Mode
