Thread: High and Low values in column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default High and Low values in column
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



Reply With QuoteReply With Quote