| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting symbols not available in excel | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Linear Mode
