Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
High and Low values in column
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
High and Low values in column
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|