Hi,

First extract the unique values by using advanced filters (check the box for
advanced filters and leave the criteria blank). Now you can use the MAX()
finction

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe Gieder" wrote in message
...
First thank you for looking at this
I have a list of part numbers that appear multiple times and I want to
first
extract each unique part number and then use that value and find the
maximum
price listed for it. I have tried this formula for the max price part
=MAX(OFFSET(A3,MATCH(A3,$A$3:$A$3500,0)-1,9,1,1))
but it doesn't give the right result, it seems to find the first match.
And
I have no idea on the unique part number part.
Please help if possible
Thank you
Joe