Which formula to bucket range of numbers
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
|