#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Is that ok for you?
|
#3
|
|||
|
|||
Thanks, cobbe, but I'm afraid it did not work for me.
Just to clarify something: in cell A1 I have "apple (1); orange (2); pear (3)" and in cell B1 "apple (1); pear (3)". Thanks anyway! |
Tags |
compare;extract;diference |
Thread Tools | |
Display Modes | |
|
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 |