| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare String in Cell to an Array
I am wanting to take a string in a cell containing multiple data elements to
an array and have the data in the cell either trimmed or to highlight the element that is matched in the array. Example: Cell B2 contains: MROMANO | MTELLIG | JGURECK | MWOLK | LGAZDA | GVANBUH | CSHOAF | STILLER | RVERBIC | DSTEPHE | BLANGLI Cells AA2:AA10 contain the array for comparison. I am not sure where to proceed from here since this appears a bit complex from the onset. Thanks in advance for any insights. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum numbers in cell string array | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
Threaded Mode
