Search : in
By :

Matching data in 2 worksheets

neelie, on Nov 4, 2009 5:06:40 am GMT 
 Report this message to moderators

Hello,

I have two work sheets, both with columns (1) Address, (2) price and (3) date. I need to create another column to match worksheet 1 against that of worksheet 2, using the 3 columns data (i.e. to make sure that data in worksheet 2 appears in worksheet 1. If not, the match results should be able to give an indication). Please help me on this issue! Thank you!

Configuration: Microsoft Windows XP Professional
Ms Office 2007

Configuration: Microsoft Windows XP Professional
Ms Office 2007

Best answers for « Matching data in 2 worksheets » in :
Connecting two computers with a USB cable. ShowConnecting two computers with a USB cable. What to choose? How does it work? What to do? If you have to transfer huge files from one PC to another, using a flash disk or burning a CD-ROM can seem like a waste of time. One wise way...
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
PS/2 connector ShowPS/2 connector The PS/2 connector (mini-DIN6 format) is mainly used to connect computers to keyboards and mice. Pins Pin number Function 1 Clock 2 Ground 3 Data 4 Ground (or not...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Ethernet ShowIntroduction to Ethernet Ethernet (also known as IEEE 802.3 standard) is a data transmission standard for local area networks based on the following principle: All machines on an Ethernet network are connected to the same communication line, made...