Hello,
I've got a long column with variable data (average selling prices of a product) and I'd like to convert this variable data into categorical data. Specifically, I'd like to create "categories" for ranges of prices (eg. $300-$320, $321-$340, $341-$360, etc.) such that each variable price falls into a specifc bucket depending on it's value.
My variable data is listed in column A. In column B, I'd like the designated price category to appear. For example, if cell A1 is "$352", then cell B1 would report "$341-$360". And so on.
Thanks in advance for any help you can provide!
Bookmarks