High and Low values in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Coleman - 26 Jan 2007 22:41 GMT

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

Reply to this Message

Don Guillett - 26 Jan 2007 22:47 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 4 lines]
> Thanks,
> Lee Coleman

Reply to this Message

Gary''s Student - 27 Jan 2007 11:31 GMT

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

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Signature

Gary's Student
gsnu200702

> 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
[quoted text clipped - 3 lines]
> Thanks,
> Lee Coleman

Reply to this Message

Rate this thread: