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