|
|
#1
10-11-2016, 09:18 AM
|
|||
|
|||
How to compare 2 cells with text and extract diferences to a 3rd one
Hello,
I have 2 columns with text in cells. Each cell has a concatenation of names, separated by ";". What I have looks like this (simplified example): Column A apple (1); orange (2); pear (3) Column B apple (1); pear (3) I need to extract to column C the names in column A that are not in column B. So I should get to "orange (2)" in Column C. Can anyone give me a hint on how to solve this, please? Thanks in advance, AV 
|
| Tags |
| compare;extract;diference |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match
|
krispykreme | Excel Programming | 1 | 09-09-2016 11:25 AM |
|
Automatically extract cells to summary table
|
taryn | Excel | 2 | 05-04-2016 04:50 AM |
|
Formula, Compare two cell's text and based on results output a number
|
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
| Compare text from Bookmark with text from Text box | Byron Polk | Word VBA | 4 | 07-30-2014 06:18 AM |
| Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Windows 7 64bit 
Office 2013
Threaded Mode