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
 

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

SSD storage news 6
How do I get Excel to make highest #, 1 color, & lowest # another? 1
Return Column Heading based on value in row 2
Compare Cells of Text and Return Highest Value based on a Customiz 1
IF Statements 3
Calculating High and Low 2
Find Min and Max in variable length arrays 1
Sorting by "High", "Medium" and "Low" 7

Back
Top