Duplicates

[Chiips]

I sell a lot of motorcycle items on eBay, and eBay's duplicate finder is slightly more advanced than Excels so I am having a little trouble. I work with a large list of bikes and sometime the strings of information get muddled into different orders. e.g.

CBR125 Air filter
Air filter CBR125

eBay deem these as duplicates, however Excel does not. Is there any way to fish out these kind of duplicates using Excel?

Appreciate and help with this.

 

[entaroadun]

There is no way without using VBA I think.
But you can compare text lengths, and then check if they are duplicates for the same length manually. Just insert this formula '=LEN(A1)- (LEN(A1)-LEN(SUBSTITUTE(A1," ","")))
So it will give you the text length without spaces " ".

 

[Chiips]

There is no way without using VBA I think.
But you can compare text lengths, and then check if they are duplicates for the same length manually. Just insert this formula '=LEN(A1)- (LEN(A1)-LEN(SUBSTITUTE(A1," ","")))
So it will give you the text length without spaces " ".

Yes I was assuming the VBA route would have to be taken :/.

In terms of comparing text lengths, I don't feel that would be much use as I'm working with thousands of rows of data, it just wouldn't work. But thanks for the suggestion.