finding common data

C

cheric

I use Excel 2000, How do I find common data from 3 columns of different size?
For instance, finding a name that appears in all 3 columns
 
M

Martin P

Suppose you have data in columns A to C. In D1 enter
=AND(COUNTIF($A:$A,A1)>0,COUNTIF($B:$B,A1)>0,COUNTIF($C:$C,A1))
and copy.
 
Top