View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Which formula to bucket range of numbers

Enter in B1 and copy down...

=(ROUNDDOWN(A1/100,0)*100)&" - "&((ROUNDDOWN(A1/100,0)+1)*100)

assuming your data is in COL A
"marq" wrote:


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