S
septillion
Hi there,
I have a problem with a PivotTable and the "Group and Show Detail ->
Group" function.
Basically what's happening is that I have a column, 'TimeStamp', with
dates and times, of the format dd/mm/yyyy hh:mm:ss, which I am grouping
according to date, hour, and minute (seconds don't really matter). When
I do this, Excel puts in two extra coulms, one for date, and one for
hours, and appears to change the format of TimeStamp to minutes; thus
shifting the table two columns to the right.
Sometime later, when I reopen the file, the first two columns
disappear, but the TimeStamp column is still sorted as I want. Any idea
why the sorting is sometimes done in the one column, and other times it
is done in three? It's really annoying cos I need to cross reference
those cells elsewhere, and the cells I'm after keep shifting!
Cheers
I have a problem with a PivotTable and the "Group and Show Detail ->
Group" function.
Basically what's happening is that I have a column, 'TimeStamp', with
dates and times, of the format dd/mm/yyyy hh:mm:ss, which I am grouping
according to date, hour, and minute (seconds don't really matter). When
I do this, Excel puts in two extra coulms, one for date, and one for
hours, and appears to change the format of TimeStamp to minutes; thus
shifting the table two columns to the right.
Sometime later, when I reopen the file, the first two columns
disappear, but the TimeStamp column is still sorted as I want. Any idea
why the sorting is sometimes done in the one column, and other times it
is done in three? It's really annoying cos I need to cross reference
those cells elsewhere, and the cells I'm after keep shifting!
Cheers