You can get min and max by catagory by using a Pivor table. see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Student
gsnu200702


"Lee Coleman" wrote:

Is it possible to show the high and low values in column b based on the
grouping in column a? I have a customer list with the prices each customer
paid for the products. I want to know what the highest and lowest price each
customer paid for their products. Is this possible using Excel 2000 or 2003?

Thanks,
Lee Coleman