Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing text cells
I want to compare two lists of comma delimited text items in two separate
cells and then determine which items are in one cell and not in the other, and visa versa. The available functions do not seem to support this, except EXACT, which simply returns TRUE or FALSE. I want the items that represent the difference between the cells. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing cells that contain numbers and text | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Comparing text strings in cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) |