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".
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/ ** *************************************************************************