| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
common characters in seperate strings
I have two columns of names. I would like to identify similar names
between the two columns for a possible match. For example column A row 13 = "Epogen"; column B row 15 "Epogen / 100 mg". I would like to indicate next to b 15 that it is a possible match to column a row 13. I tried an array formula like =IF(COUNTIF($a$8:$a $15,b15)0,+b15,"") but that only works if there is an exact match. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup strings with ~ and ^ characters | Excel Worksheet Functions | |||
| Replacing characters in numeric text strings and SUMming | Excel Discussion (Misc queries) | |||
| characters and strings | Excel Discussion (Misc queries) | |||
| Numbers from seperate worksheet to common sheet | Excel Worksheet Functions | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
Threaded Mode
