How do I find items common to two columns in Excel?
 

You can use the MATCH function for this. If your two lists are in Sheet1!A:A
and Sheet2!A:A, then in Sheet1!B1 enter =match(A1,Sheet2!A:A,false). Copy
that formula through the entire column. Where the result is a number, the
corresponding ticker is on Sheet2 as well. (If Sheet2 happens to be in
another workbook, the format becomes [BookName.xls]Sheet2!A:A; either way,
the easy way to enter the table_range is to click on the column of tickers in
the other sheet while entering the 2nd function argument).

"TJ auminer" wrote:


I have two excel spreadsheets with over 1000 stock tickers each. One has
stocks with high growth-rate attributes, the other is value-oriented
attributes. Oddly, some tickers are on both lists.
I want to find a way to quickly find stocks that are unique to either list,
or more importantly, exist on _both_ lists. I've found a 'back-door' way to
do it, but it's too complex to explain succinctly, and it seems that there
must be a function for this... I just can't find it.