[CGUYS] Excel Pivot Tables

2010-01-20 Thread Jay Montero
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. * ** List

Re: [CGUYS] Excel Pivot Tables

2010-01-20 Thread tjpa
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

Re: [CGUYS] Excel Pivot Tables

2010-01-20 Thread Jay Montero
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