Hi Jan,

In Excel 2003, you could enter the range 5 to 8 in separate worksheet cells,
then use a helper column next to the original data with a simple If
statement to group the values into the range. I have set up a sample
worksheet here; http://www.edferrero.com/SelectingRa...ivotTables.zip

Ed Ferrero
www.edferrero.com