Bucketing data into ranges

[Dolemitefunk]

Hello I am wondering if there is a way to put data into buckets in excel. I am using a large data set, and one of the fields can be numbers from -100 to 400. I want to bucket these numbers into groups of 5, meaning if the value is -98 I would like the output to be "-100 to -95", and if the data is 43, I would like the output to be "40 to 43" . Since there are many different buckets I cannot use a if statement (that and it would lock up my excel to do it for 50,000+ records.

Is there a quick way of doing this in either excel or VBA?

Any help would be appreciated

 

[Dolemitefunk]

I meant "40 to 45"