Comparing data in columns

[jerk_lip]

I have, let's say three columns of data. Each column has hundreds o
rows.

For example, say the data is Social Security numbers.

Which Social Security numbers show up in all three columns.

How do I isolate the numbers that show up in all three columns?

Thank

 

[Frank Kabel]

Hi
have a look at the following site to extract common entries of two
lists (you may repeat this step for the third list with the result of
the comparison of list 1 + 2)
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[jerk_lip]

Thanks Frank...I'll go check it out.