Hi there,

I was wondering if you guys can come up with a easier and quicker solution
to work with ranges in Excel.
For example:

I need to classify prices ranges.
PRICE
$2.50
$1.72
$12.00
$4.50

RANGES
<$1.00
$1.00 AND <$5.00
$5.00 AND <$10.00
$10.00

I can do this, using IFs but if you dramatically changes the ranges and
include many, it's very time consuming.

How can I do this on a more automated fashion?

Btw, Excel could provide some wizard tool to create those ranges as it has
for subtotals, pivot tables, etc.

Thanks