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 <email@example.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?
>====================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
>For a list of commands to manage subscriptions, send the command
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
For a list of commands to manage subscriptions, send the command