Please clarify your example. You say that John Smith & Sean Mann share 2
classes, but that Julie Jones doesn't, and yet Julie Jones is in 84744.4 (as
are John & Sean). Why is Julie Jones excluded from the "shares 84744.4 with
John & Sean" list?


"Elliot" wrote:

Hi,

I need to find duplicate data from the data table below.

There are 2 columns : one consists of students and the other is an
individual class number. The class number could have 3 or 30 students but it
is UNIQUE.

What I wish to do is to be able to find students in a particular class and
cross reference this to see if there are one or more students that share
subsequent classes.

In the Below example : John Smith and Sean Mann share classes in 84749.2 &
84744.4.

Julie Jones has 2 classes but doesnt share with anyone.

Is there a way to single out all the entries of those that share classes?

Thanks

Elliot


STUDENT CLASS NUMBER
JOHN SMITH 84749.2
SEAN MANN 84749.2
PETER JONES 84749.2
JULIE JONES 84744.7
SARA SMITH 84744.7
BOB SCOTT 84744.7
JOHN SMITH 84744.4
SEAN MANN 84744.4
JULIE JONES 84744.4