We are looking for someone to develop a tool that enables us to find and delete duplicate cells within a large list. The reason we need a custom tool writing is because it is not a standard duplicate function.
'Ford Focus Blue 2003'
'2003 Blue Ford Focus Ghia [url removed, login to view] Petrol'
These two titles would be classified as 'duplicates'. Despite the two titles clearly not being the same (regardless of the word order) but because ALL of the words in the top line are also in the bottom one (Ford, Focus, Blue, 2003) we would need it to be deleted.
So, this means that if we were to add the word 'ABC' to the top title it would be fine because the bottom title doesn't include the word 'ABC'. This isn't however what we would like to do (we are looking to delete cells that qualify as duplicated) but it demonstrates the definition of 'duplicate' that we need to work with.
We are making these changes to conform with the recent changes to eBay UK's duplicate listing policy (see below).
[url removed, login to view]
As far as the interface goes it doesn't really matter whether it is based in Excel or in browser etc as long as the functionality is present. Please message us for any more info and how you would achieve this.