View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
NetNewbie NetNewbie is offline
external usenet poster
 
Posts: 4
Default Display ranges in a Pivot

Hi all,

I have a column called IncomeRange. I need to display the value in ranges
like 0 - 100, 101-200 etc., How can I convert a column in a pivot report to
display as ranges? Is this an option or do I need to do some kind of formulas
or macros?

Thanks for all help