View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
Posts: 2,480
Default Which formula to bucket range of numbers


Why not leave your data as it is, and retain the accuracy, but in the PT
Group the data in bands of 100

Roger Govier

"marq" wrote in message

I have a column of random numbers. In a second column I want to group
these numbers by creating a text that reads 1-100, 101-200, 201-300
etc. This will greatly reduce the number of rows of data and make
pivot table more effeciently.

6 1-100
234 201-300
188 101-200
44 1-100
1123 1101-1200