#1
|
|||
|
|||
Name mismatch b/n two columns
Hi
How do I identify name mismatch between two columns. Each cell has a persons last name followed by a backward slash then his first and middle name afterwards (middle name might not always be included). If one of the three names on the first column is similar to any type of the names on the second then I want it to mark as acceptable. I am a dummy when it comes to Excel and I'd appreciate it if anyone can help me on this. My Thanks Kindly check ad help me in a matter of good time please check the right moment when it is all |
#2
|
|||
|
|||
Use this formula is cell C2, and copy paste in all the cells:
=OR(LEFT(A2,SEARCH("/",A2)-1)=LEFT(B2,SEARCH("/",B2)-1),RIGHT(A2,LEN(A2)-SEARCH("/",A2))=RIGHT(B2,LEN(B2)-SEARCH("/",B2))) It would return a TRUE when there is a match and FALSE is there is not. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Heading 1 and Table & Figures style mismatch | ezrayst93 | Word | 5 | 07-21-2014 11:06 PM |
Colour mismatch inserting pictures into Powerpoint 2010 | Osprey | PowerPoint | 0 | 10-25-2012 08:44 AM |
VBA in Excel: Add a new Word Document on Template (Type Mismatch Error)) | tinfanide | Excel Programming | 1 | 03-29-2012 09:10 AM |
[Mismatch] Help needed!!!!!!!! | rockfielder | Word | 3 | 08-25-2011 11:45 AM |
Resolution mismatch | Adforum | PowerPoint | 5 | 05-25-2011 12:24 PM |