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
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
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