View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Pivot table to query data in a set range

You can do with Auto Filter.


"adman4" wrote:

I'm with a real estate company and we do a lot of analysis of properties in
specific price ranges. Is there a way in a pivot table to set filters by a
range of data? For example, I want to look at average days on market for
properties that are priced $500K to $1M?