finding common data
 

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

finding common data
 

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

"cheric" wrote:

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