I'm trying to consolidate a worksheet that has multiple columns however it's consolidating the wrong columns. The layout of the columns in the sheet are PO ID, Vendor ID, Vendor Name, Encumbered, Vouchered. What's happening is that the consolidation is working correctly on PO ID, Encumbered and Vouchered however I do not want it to perform the consolidation on the vendor ID but rather remove the duplicates it comes across. Is there way any to do this? If so can some point me in the right direction.

Thanks much.