Extract Duplicates?

I have a spreadsheet that shows four columns of data (actorss names). For ease of explanation, columns A-D have the names of these actors. The heading for each column is a movie name.

I need to know how to have Excel look at this data and return the values of actors who only appear in ALL FOUR columns (movies).

I would like each actor matching this criteria to be listed in column E. Can this be done?

Hi,

Assuming that your data are in coloumns A,B,C & D

1-Sort each column separetely
2- in e2 type =IF(AND(A2=B2,A2=C2,A2=D2),A2,"NOT REPEATED")

Regards

Try this:

Book1.xls

It reference on value in first column. But since all four column must be included that's OK

Of course, that can be joined int one formula:

=IF(AND(NOT(ISNA(MATCH($A1;B$1:B$1000;0)));NOT(ISNA(MATCH($A1;C$1:C$1000;0)));NOT(ISNA(MATCH($A1;D$1:D$1000;0)))
);A1;"")

(replace ; with , if you get error)