To bucket range of numbers in Excel, you can use the following formula:

Here, A1 is the cell reference of the first number in your column. You can adjust the ranges as per your requirement.

Follow these steps to apply the formula:

1. In the second column, click on the first cell where you want to apply the formula.
2. Type the formula mentioned above in the formula bar.
3. Press Enter to apply the formula to the cell.
4. Now, click and drag the fill handle of the cell to apply the formula to the remaining cells in the column.

This will bucket the range of numbers in the second column as per the specified ranges. You can now use this column to create a pivot table and analyze your data more efficiently.