I am new to StackOverflow, apologies in advance if I am not going about this in the right way.

I have some raw data that looks like the following:

![enter image description here](https://i.stack.imgur.com/zP0br.png)

All the values are separated by commas, in this string I am looking to find if the full range of numbers (1,2,3,4,5) is found, if it does, then it should return a 100% match.

In case only 4 numbers out of this range are found then it should return 80%, for 3 numbers 60%, for 2 numbers 40%, for 1 number 10% and in case none are found it should return "none". (see desired output below)

![enter image description here](https://i.stack.imgur.com/QLn6K.png)

I am still new to VBA, but my thought was to split my comma separated values into an array, and then try to find a match. However unfortunately I already got stuck at the first match (i.e. finding 100%).

```
Sub CheckNumberMatches()

Dim i As Long
Dim Elem As Variant
Dim myArr As Variant

With Worksheets("data")
    For i = 1 To .Cells(.Rows.Count, "A").End(xlUp).Row
        myArr = Split(.Range("A" & i).Value, ",")

        ' loop through array elements and look for 1,2,3,4,5
        For Each Elem In myArr
            If Elem Like "1,2,3,4,5" Then
                .Range("B" & i).Value = "100%"
                Exit For
            End If
        Next Elem

    Next i
End With

End Sub

```

After @FunThomas his reply, I realize my requirements are not very clear, let me provide a few more examples of what can happen:

* The main criteria is (1,2,3,4,5) needs to be found in the cell, but this does not need to be in numerical order, i.e. can be random (2,4,1,3,5). If all these numbers are found in **any order** it should be 100%.
* If for example all five numbers are found (1,2,3,4,5) in the cell, but the cell also includes other numbers (1,2,3,4,5,6,7) - it should still be counted as 100%.
* If for example only four numbers of the main criteria are found (for example: 1,2,4,5) it should be considered as 80% (as long as 4 out of main numbers are found), likewise for 3, 2, 1 and 0 matches.
* The data can have gaps, i.e. it can be a range of (5,2,7,11,12), in this particular example it should be counted as 40% (2 out of 5 choices are found).
* Duplicate numbers are not possible.

I hope that clarifies.