generate a list that both columns have in common

It seems simple but I can't figure it out...

I have two columns of stock tickers. Let say column A has 500 tickers and column B has 900 tickers. How do I generate the list of tickers that both columns have in common? Thanks in advance for any help.

Use =if(col1=col2,"Duplicate","No Duplicate")

I think this may help you.....

G.N.Senthil Kumar
India

Try this,

Suppose A1:B1 is field name.

A. Advanced Filter

1. Enter =Isnumber(match(A2,$B$2:$B$900,0)) in cell D2
2. Click A1
3. Data > Filter > Advanced Filter
4. Select Copy to another location
5. List range: A1:A500
6. Criteria range: D1:D2
7. Copy to: E1
8. OK

B. Formula approach

1. C5

Please Login or Register  to view this content.

2. C7

Please Login or Register  to view this content.

Ctrl+Shift+Enter and copy down.

Hope this helps.