J
Joe Gieder
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
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