N
Nateysz
Hello,
I'm using very big Excel file, where some rows is redundant...
Problem is not obvious, because redundant entry doesn't contain the same
information (for example:
new product
product new
n.e.w. product
new prod
all of aboce contain information about the same product.
I'm thinking about writing macro which get some characters from left,
than try to find in other rows....
next get some character from right, than try to find...
and so on..but maybe You have more efficient algorithm or any
idea how to do that ?
I'm using very big Excel file, where some rows is redundant...
Problem is not obvious, because redundant entry doesn't contain the same
information (for example:
new product
product new
n.e.w. product
new prod
all of aboce contain information about the same product.
I'm thinking about writing macro which get some characters from left,
than try to find in other rows....
next get some character from right, than try to find...
and so on..but maybe You have more efficient algorithm or any
idea how to do that ?