| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare name in cells
oops. replied to wrong mail.sorry
"Patrick Molloy" wrote: change this Set rng = Intersect(Target, Range("E:E")) to Set rng = Intersect(Target, Range("E:E;H:Q")) "Dan" wrote: 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 |
| Reply |
| 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 | |||
![Patrick Molloy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
