Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 text colomns and match rows depends by cell content
Hello, I have a dificult problem, i have 2 lists of products name, one of them is the original list from my database and the other one is a supplier list. I put my list in colomn A and supplier list in colomn B. I want hel for a macro to comare every rows from my list with every rows from supplier list and match rows by must aproiate content in other colomn/colomns if are more that one match. If for a row from my list is not match, the results will be: "not match" Example colomn A: TINCTURA AFIN 50ml HOFIGAL TINCTURA ALOE 50ml HOFIGAL TINCTURA ARDEI IUTE 50ml HOFIGAL TINCTURA ARMURARIU 50ml HOFIGAL TINCTURA ARNICA 50ml HOFIGAL TINCTURA BRUSTURE 50ml HOFIGAL colomn B: Tinctura Aloe Tinctura Trei Frati Patati Ulei Catina Ulei Lavanda Ulei Masaj Tinctura Busuioc Tinctura Brusture Tinctura Arnica colomn C: NOT MATCH Tinctura Aloe NOT MATCH NOT MATCH Tinctura Arnica Tinctura Brusture Thanks, Marian -- PRONET ------------------------------------------------------------------------ PRONET's Profile: http://www.excelforum.com/member.php...o&userid=36885 View this thread: http://www.excelforum.com/showthread...hreadid=566691 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Rows depends on the number in a cell | Excel Worksheet Functions | |||
Compare 2 cell content and match them if 2 or 3 words are identicaly | Excel Programming | |||
how to display different content depends on some conditions? | Excel Programming | |||
Compare and match names and extract a cell content | Excel Worksheet Functions | |||
how to select range when no. of rows depends from text place ?? | Excel Programming |