Sort

  • Thread starter Thread starter Omer
  • Start date Start date
O

Omer

How do I make Excel sort throught two column and tell me
the common names between both column.

Thx
Omer

Column A Column B
John William
Eric Marc
Kevin Max
Tim Eric
Alan Adam
Chris John

End result: John and Eric are Common between both sets of
data.
 
One Idea

A B C
John William 0
Eric Marc 0 c1 = =COUNTIF($A$1:$A$6,B1)
Kevin Max 0 and copied down
Tim Eric 1
Alan Adam 0
Chris John 1
 
Back
Top