High and Low values in column

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get Excel to make highest #, 1 color, & lowest # another? 1
Calculating High and Low 2
multiple lookup 4
Return Column Heading based on value in row 2
Find Min and Max in variable length arrays 1
In col if high is 83 and low 15 how do i get high =100 and low=0 2
Combining two ranges based on common a common value 5
in a single worksheet,hw to match values based on 2 list 2

Top