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

This is an array formula which must be entered/edited with ctrl+shift+enter
=MIN(IF(C3:C33="customerA",D3:D33))
=max
--
Don Guillett
SalesAid Software

"Lee Coleman" wrote in message
...
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

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