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
|