Thanks for the help. Much obliged. > > On Jan 20, 2010, at 8:07 AM, Jay Montero wrote: > > Does anyone know how to get an Excel (2007) pivot > table to accept a > > range as a criteria in a column heading? It will > allow using a > > constant but I need it to allow a range of values as > in ">20 and <50".
--- On Wed, 1/20/10, tjpa <[email protected]> wrote: > With my Excel 2004 (Mac) you right click on any row or > column label > and select "Group." In the resulting dialog box you can > specify > intervals. > > YMMV > > > ************************************************************************* > ** List info, subscription management, list rules, > archives, privacy ** > ** policy, calmness, a member map, and more at http://www.cguys.org/ ** > ************************************************************************* > > ------------------------------ > > End of COMPUTERGUYS-L Digest - 19 Jan 2010 to 20 Jan 2010 - > Special issue (#2010-34) > ************************************************************************************ > ************************************************************************* ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *************************************************************************
