| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search for one column values in another col ?
Hi, I like to find all col1 ocurrences in all Col2 values
For example IF I have "sarah" in Col1, I like to find in Col2 values such as 1 " sarah" 2 "sarah blah" 3 "blah blah sarah" *blah* be anything But I dont want to use string comparision like below, that take plenty of time col1 like * " " col2 " " * etc Anything better appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search for one column values in another col ?
use the spreadsheet autofilter and set the column to "contains" -----Original Message----- Hi, I like to find all col1 ocurrences in all Col2 values For example IF I have "sarah" in Col1, I like to find in Col2 values such as 1 " sarah" 2 "sarah blah" 3 "blah blah sarah" *blah* be anything But I dont want to use string comparision like below, that take plenty of time col1 like * " " col2 " " * etc Anything better appreciated . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search from range in column 1 and print from corresponding values | Excel Discussion (Misc queries) | |||
| Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
| Find and sum values based on a column search | Excel Discussion (Misc queries) | |||
| Search based on comparing several values in the same row and column | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Linear Mode
