View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manfred Manfred is offline
external usenet poster
 
Posts: 6
Default Clarification: Finding/Listing Symbols Found in 2 Columns

I thought I knew how to perform the following simple function, but I must be
missing something basic.

The problem: I am assembling a spreadsheet consisting of 2 columns
of symbols. The two columns may or may not have matching symbols.

The question: Is there a formula what will search through both columns and
list symbols that appear in BOTH columns, LISTING these symbols in a
separate third column?

Thank you for any response.