Sort

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.
 
L

Lance

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supervisor Hierarchy 0
Combine two cells without losing data cell formats 3
Specific words Categorizaion 1
copying cell contents from one worksheet to another (re-sorted lis 2
Insert and Update data 2
Sort Issue 2
Sorting 5 columns of data based on column A 6
Sorting Madness 5

Top