PIVOT Consolidating Data

[garyfjh]

Hi,

Need help.

I had used PIVOT to consolidate my data on the qty merge with same part numbers but I do not want my cost to add up as well.

Is there anything I can do to avoid this or can I do another vlookup if this is the limitation?

Is like picking up the highest cost.

Thanks for helping.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.