View Single Post
  #3   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

Hi

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

--
Regards
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




--
marq