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
|