View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manfred Manfred is offline
external usenet poster
 
Posts: 6
Default Finding/Listing Symbols from 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 simply off 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 only that appear in both columns? If so, can somebody please
list the steps?

Thank you for any response.