In column A are part numbers, running down to row 800. There are twelve
different parts numbers. Column B has the price acheived for each sale.
The same part can be sold at different prices. If I list the twelve part
numbers in column C1 - C12, how can I put the minimum and maximum prices
acheived for each part in columns D & E without sorting column B. I
thought DMAX would work but it's either unsuitable or I'm using it
wrong.

Thanks for any ideas


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=550293