Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2010, 06:33 AM
youngsc youngsc is offline Excel Consolidation Problem Windows XP Excel Consolidation Problem Office 2007
Novice
Excel Consolidation Problem
 
Join Date: Mar 2010
Posts: 2
youngsc is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-29-2010, 06:49 AM
youngsc youngsc is offline Excel Consolidation Problem Windows XP Excel Consolidation Problem Office 2007
Novice
Excel Consolidation Problem
 
Join Date: Mar 2010
Posts: 2
youngsc is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Consolidation Problem 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 Consolidation Problem 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
Excel Consolidation Problem MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft