| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Are contents of at least one cell in a group a substring of a dif
excel2007
I have a list of 100k text cells in sheet1, column A: charles schwab layoffs mcmaster carr aig bonuses slalom consulting company reviews cbeyond reviews .... In sheet2, column A, I have a list of 50k company names: coca cola home depot charles schwab aig .... I would like to put a "1" in sheet1, column b for every cell in column A that contains a company name that can be found in sheet2, column A. If the cell doesn't contain a company name, I would like to put a "0". For example, "charles schwab layoffs" would get a "1" because it contains "charles schwab" but "company reviews" would get a "0" because it doesn't contain a company name. I would just use the find function if I was only dealing with a few companies but I am hoping that there is a formula that would be able to deal with a large list of cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter substring of a cell | Excel Discussion (Misc queries) | |||
| Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
| Substring | Excel Discussion (Misc queries) | |||
| If you delete the contents of a cell in a worksheet in a group, w | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Threaded Mode
