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