Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2011, 12:31 AM
goodhope goodhope is offline Compare tables and mark differences (vlookup? Windows XP Compare tables and mark differences (vlookup? Office 2007
Novice
Compare tables and mark differences (vlookup?
 
Join Date: Mar 2011
Posts: 1
goodhope is on a distinguished road
Default Compare tables and mark differences (vlookup?

hi all
i need to compare some tables and someone told me to use vlookup, but he couldn£t explain it to me.
so it would be cool if someone here could help me. i can not spend a lot of money on this, and i guess it
is just a matter of seconds for an excel specialist. but i could pay usd 10, so at least it is a a visit to the cinema or so :-).
so once again, i have 5 tables (one per person) in an email which i copied into an excel sheet. each table has 2 columns. in this tables are applications and prio, these are different, so the goal is, that every person has the same application and prio and that the changes are somehow marked, so that i can see who needs the application and which prio which prio has to be changed.


i hope i explained it correct in englisch and i hope someone can help me.

This is the spreadsheet: https://spreadsheets.google.com/ccc?key=0At-TqJDHaIEUdDRlcWZtelh0WENUVUVneWUxNVBXUHc&hl=en&aut hkey=CK-05ukN
Reply With Quote
  #2  
Old 03-26-2011, 10:29 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Compare tables and mark differences (vlookup? Windows 7 32bit Compare tables and mark differences (vlookup? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

The help provided on this forum is offered by volunteers and is free.

Please can you attach your Excel workbook directly to this thread and show us a "before" and "after" so we can see how you want the differences to be displayed? And just to be clear, you are using Microsoft Excel and not Google Spreadsheets?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare tables and mark differences (vlookup? Random formatting differences between what I send and what is received djmills32 Outlook 7 11-30-2010 04:45 AM
How to compare certain items in document A & B? networkerz Word 0 10-16-2010 09:55 AM
Question regarding differences among styles bigsnowdog Word 0 08-01-2010 02:41 PM
Compare document enthu Word 1 05-19-2010 10:32 PM
Compare tables and mark differences (vlookup? compare files rmartin8 Word 1 02-10-2009 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.


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