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