Identify common individuals and exclude the rest from two sets of data

[mikenikes]

Hi!

I am currently investigating two periods in time: 1990 and 2000, and the change for 3000+ individuals in approx. 20 different variables.

In the 1990 dataset I have 3354 individuals that are identified with a code-nr that runs from 10000 to 34907.

The 2000 dataset includes some of these individuals, as well as a significant number of new survey respondents. In the same way, the 1990 dataset includes respondents that did not participate in the 2000 survey.


My problem is that I need a means of having excel identify only those observations where the respondent ID is observed in both time instances, and delete (the entire row/information for all variables) those that are not present in both data sets.

Any tips on how I can manage this?

Thanks,

Mikenikes

 

[Gary McMaster]

It's a rather crude process but if it's a one time thing then it's probably not worth spending any more time on it.

Glad it helped.

Gary

 

[seboseszuk]

Hello Mike,

A vba program 23 lines long removes all lines of data that occur in one data line only.
The personal ID is assumed to be in column A.
You can specify the number of columns that you want to clear for the singular data.

HTH

Gabor

 

[seboseszuk]

Hello Mike,

A 23 line program in vba eliminates all but the common individuals (line of data with an ID that is unique for the line).
The user can specify the number of columns a line of data contains.
HTH

Gabor