| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to figure out a formula for range of numbers? | Excel Worksheet Functions | |||
| Need 3D formula for a range of numbers across several worksheets | Excel Worksheet Functions | |||
| Subtract Range Of Numbers using a Formula | Excel Discussion (Misc queries) | |||
| formula to select numbers from a range | Excel Worksheet Functions | |||
| Range of numbers in a formula...PLEASE HELP!!! | Excel Worksheet Functions | |||
Threaded Mode
