Group on numbers (Range) Formula

[dva94]

Hello guys,
I need help on project that I'm working on. I need to made a excel spreadsheet showing group of numbers (range) from 1 to 50000 as follows:

1 to 50 (or could be 1-50)
51 to 100
101 to 150
151 to 200
.
.
.
.
down to
49951 to 50000 (or 49951-50000)

I would appreciate any advice on how to create formula to do that.

Thank you,

[adhawan06]

Hi dva94,

Let's say you have list of numbers in sheet1 in column A. Simply select this column and create a PivotTable (you can select where you want to create in new sheet or existing sheet). Once the pivot table is created, drag Column A heading to "Rows" field and then right click anywhere on any number. There you will see a option called "Group", click on that. Here, you can set "Starting at" as 1 and "Ending at" as 50000 and "By" as 50. You can change this interval as per your choice.

This is the easiest solution without even using formula. I hope this solve your problem.