Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 cell content and match them if 2 or 3 words are identicaly
Hello, I manage an ecommerce site and i need a tool to compare an old list with products name with other new list with products name and match the rows by number of words from cells. example: cell 1 = laptop toshiba 17'' intel P4 HDD 5GB cell 2 = laptop toshiba 5GB step 1: i want to select the filename 1 and filename 2 step 2: i want to select the sheet 1 and sheet 2 step 3: i want to select the range/colomn for sheet 1 and sheet 2 step 4: i want to input the minimal number of words for matching (matching at row nivel) step 5: the program must dislay the results in a new sheet, in 2 ore more colomns, row by row; if are more that 1 match in results it will be write in a 3 colomn. order to dislay colomn: colomn 1: rows from first sheet colomn 2: rows from second sheet - first match result column 3: rows from second sheet - second match result ...... I find on the net many applications but they solve just a part of problem (not to words nivel) ex: excel compare excuse me for my english. thenks for any sugestion or help Marian -- PRONET ------------------------------------------------------------------------ PRONET's Profile: http://www.excelforum.com/member.php...o&userid=36885 View this thread: http://www.excelforum.com/showthread...hreadid=566016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare cell content to a row pf data in excel and return . | Excel Discussion (Misc queries) | |||
Compare and match names and extract a cell content | Excel Worksheet Functions | |||
Compare cell content from two worksheets | Excel Programming | |||
Match Cell content in another workbook question | Excel Programming | |||
how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions |