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

=SUMPRODUCT(ISNUMBER(MATCH(A2:A500,B2:B900,0))+0)

2. C7

=IF(ROWS($C$7:C7)>$C$5,"",INDEX($A$2:$A$500,SMALL(IF(ISNUMBER(MATCH($A$2:$A$500,$B$2:$B$900,0)),ROW($A$2:$A$500)-ROW($A$2)+1),ROWS($C$7:C7))))

Ctrl+Shift+Enter and copy down.

Hope this helps.