| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare name in cells
I have 2 cells that I need to compare
In each cell there are name of student separated by coma so A1= Bill,Marco A2= Bill,John,Marco,Bella How can I have the unmatching names (name in A2 but not in A1) in A3 So A3 should be John,Bella Any idea? Thanks Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
| Compare 2 cells in 2 worksheets, rewrite one of the cells | Excel Programming | |||
Threaded Mode
