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
Bookmarks