Which formula to bucket range of numbers
I made a revision based on marqs original question:
(ROUNDDOWN((A1-1)/100,0)*100)+1&" - "&((ROUNDDOWN((A1-1)/100,0)+1)*100)
This would probably bucket the outliers between intervals (i.e. 100, 300)
On Monday, September 8, 2008 8:04:09 PM UTC-7, Sheeloo wrote:
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
|