Listing Common Symbols Of 2 Columns
 

I have two columns of symbols that may or may not contain one or more of the
same symbols. Is it possible for Excel to list the symbols that are carried
in both columns in a separate column? If so, can someone provide the
formula to perform this task?

Listing Common Symbols Of 2 Columns
 

Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,SMALL(IF(COUNTIF(B$1:B$20,A$1:A$20 ),ROW(A$1:A$20)-ROW(A$1)+1),ROWS($1:1)))

Copy down until you get #NUM! errors meaning all matches have been
extracted.

Biff

"Manfred" wrote in message
...
I have two columns of symbols that may or may not contain one or more of
the same symbols. Is it possible for Excel to list the symbols that are
carried in both columns in a separate column? If so, can someone provide
the formula to perform this task?

Listing Common Symbols Of 2 Columns
 

Biff,

Thank you for taking the time to answer this question.


"Biff" wrote in message
...
Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,SMALL(IF(COUNTIF(B$1:B$20,A$1:A$20 ),ROW(A$1:A$20)-ROW(A$1)+1),ROWS($1:1)))

Copy down until you get #NUM! errors meaning all matches have been
extracted.

Biff

"Manfred" wrote in message
...
I have two columns of symbols that may or may not contain one or more of
the same symbols. Is it possible for Excel to list the symbols that are
carried in both columns in a separate column? If so, can someone provide
the formula to perform this task?

Listing Common Symbols Of 2 Columns
 

You're welcome.

Biff

"Manfred" wrote in message
...
Biff,

Thank you for taking the time to answer this question.


"Biff" wrote in message
...
Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,SMALL(IF(COUNTIF(B$1:B$20,A$1:A$20 ),ROW(A$1:A$20)-ROW(A$1)+1),ROWS($1:1)))

Copy down until you get #NUM! errors meaning all matches have been
extracted.

Biff

"Manfred" wrote in message
...
I have two columns of symbols that may or may not contain one or more of
the same symbols. Is it possible for Excel to list the symbols that are
carried in both columns in a separate column? If so, can someone provide
the formula to perform this task?