ExcelBanter - pivot tableproblem in grouping

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivot tableproblem in grouping (https://www.excelbanter.com/excel-discussion-misc-queries/182003-pivot-tableproblem-grouping.html)

hitesh

pivot tableproblem in grouping

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.

Dave Peterson

pivot tableproblem in grouping

There is at least one cell that is not a date--it may be empty, it may contain
text. But it's not a date.

hitesh wrote:

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.

--

Dave Peterson

Jim Thomlinson

pivot tableproblem in grouping

Check out this link...

http://www.contextures.com/xlPivot07.html
--
HTH...

Jim Thomlinson

"hitesh" wrote:

i want group a date, but the message comes that " u cannot group the selection.

whats the reason can anyone help on this.

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