Pivot table help

[petevang]

Why when trying to use the group feature, will excel says "cannot group that selection". Is there anyway around this. I am trying to group a range of numbers? Thanks

[Debra Dalgleish]

If the field in the source data contains text or blank cells, you'll see
that error message. There's information here on fixing the problem:

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


petevang wrote:
> Why when trying to use the group feature, will excel says "cannot group
> that selection". Is there anyway around this. I am trying to group a
> range of numbers? Thanks
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html