LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Data Ranges Noakesi Excel Discussion (Misc queries) 1 May 3rd 08 04:39 PM
selecting different cell ranges across sheets, to display on summary page NetMax Excel Discussion (Misc queries) 4 January 17th 06 07:42 PM
multiple pivot ranges BorisS Excel Worksheet Functions 0 September 16th 05 02:34 PM
Display single value for multiple ranges? Chris McDannold Excel Worksheet Functions 14 August 13th 05 12:19 PM
Pivot ranges and INDIRECT daveydave60 Excel Worksheet Functions 1 April 22nd 05 12:15 PM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"