High and Low values in column

  • Thread starter Thread starter Lee Coleman
  • Start date Start date
L

Lee Coleman

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
 
Back
Top