View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
adman4 adman4 is offline
external usenet poster
 
Posts: 5
Default Pivot table to query data in a set range

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?