#1
|
|||
|
|||
Excel Consolidation Problem
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. |
#2
|
|||
|
|||
Figured out one way just had to do the consolidation less the columns I didn't want summed then bring them over with the vlookup.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help problem with excel | MMCSSK15 | Excel | 1 | 05-01-2010 11:19 AM |
Microsoft Excel has encountered a problem | suehoege | Excel | 1 | 01-06-2010 12:27 PM |
Excel Print Preview Problem | jagadiswararao | Excel | 1 | 11-29-2009 06:49 AM |
Problem with Covnverting Linked Excel Data to Text | trapdoor | Word | 0 | 05-25-2009 07:30 PM |
MS ACCESS - Import from Excel problem | Gregory_in_Montauk | Office | 6 | 05-06-2005 08:50 AM |