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