Finding duplicates when the string values are in different orders

[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? I'm assuming the VBA route may be the only way forward, of which I have little knowledge of .

Appreciate and help with this.

 

[SteveO59L]

probably helpful to post a few more examples

 

[ww4612]

i assume your SKUs exist in sheets(1).columns(1) and started at rows(2)

sub t
Dim b As Integer, r As Range, r1 As Range
With Sheets(1)
b = .Columns(1).Find(What:="").Row - 1
Set r1 = Range(.Cells(2, 1), .Cells(b, 1))
    For Each r In r1
        If Application.CountIf(Range(.Cells(2, a), r), r.Value) > 1 And (Not r.Value = "") Then
            r.Activate
            MsgBox "this string has appeared once before the active cell"
        End If
    Next r
end with
end sub

if you don;t want macro. you can use this formula: =countif(rc1,rc1:r2c1,rc1)>1.
then you just need to select that column which you input the formula. press ctrl+f and search for "true". the copy the sku which the formula output "true" and search that sku in your skus column.