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 :
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...
Uploading Large Files ShowUploading Large Files You have surely encountered various difficulties for sending files through e-mail due file limitation. You have found the elucidation to your trouble. There are several means to transfer files and data from one...
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...
Network equipment - The switch ShowSwitches A switch is a multi-port bridge, meaning that it is an active element working on layer 2 of the OSI model. The switch analyses the frames coming in on its entry ports and filters the data in order to focus solely on the right ports (this...
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...
Ask your question Reply
They need your help