How to Sort Products' Prices Into Price Ranges

Hello,

I have a list of 130,000 products and their prices. The prices range between $0.1 to $9999.

I want to assign "price buckets" in increments of 1, so any price > 0 and <=1 will get 1, > 1 and <= 2 will get 2, etc.

How do I do that? Is there a formula that can determine the price bucket for every price in the list?

Thank you

Hi
because your "buckets" will be the rounded up value of the number, this formula should do it:

Please Login or Register  to view this content.

Thank you very much!