View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicawette Nicawette is offline
external usenet poster
 
Posts: 27
Default Pivot table and value range

Hi,

I have built a simple pivot table with 2 columns : Amounts and count
of amounts

eg:

amount/Nb of amount
100 /1
150 /5
200 /6
250 /2
300 /1
450 /5
500 /9

Would it be possible to have a range of value in the pivot table to
have a result like this:
amount/Nb
0-200 /12
201-400 /3
401 /14


Thank you for your help

Thank you