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.
Bookmarks