LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (December 2008)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 12 Dec 2008 06:00:17 -0500
Reply-To:     Brad Kirby <bradley.kirby@ISD.CSA.SCOT.NHS.UK>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Brad Kirby <bradley.kirby@ISD.CSA.SCOT.NHS.UK>
Subject:      Re: Looking for Matches in SPSS and Microsoft Excel
Content-Type: text/plain; charset=ISO-8859-1

You can do this in excel quite easily. Sort column A ascending. Insert new column B, give each cell an arbitrary value, say 1. In colum D do a vlookup - something like =VLOOKUP(C1,$A$1:$B$5,2,FALSE) where its looking for the value in C and returning the lookup value in your newly created lookup table. If D = 1, then C exists in A. If D = #N/A, then C does not exist in A.

To find where A exists in C, repeat the process by creating a new lookup table for Column C.

Needs refinement but basic methodology is there.

On Thu, 11 Dec 2008 19:07:30 -0600, Hans Chen <spsshanschen@gmail.com> wrote:

>Dear Sir or Madam: > > > >There are two Columns of data which are as long as 8000 rows. Is there any >way in SPSS and Microsoft Excel to find the matches between the two columns >(they might be in different rows) and pick out those without matches? > > > >1 9 > >3 5 > >5 7 > >7 3 > >9 10 > >� > > > >Hans Chen >Canada > >====================To manage your subscription to SPSSX-L, send a message to >LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the >command. To leave the list, send the command >SIGNOFF SPSSX-L >For a list of commands to manage subscriptions, send the command >INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD


Back to: Top of message | Previous page | Main SPSSX-L page