I have the following data

```
0/3, 1/1, 3/4
1/3, 3/2, 6/2
12/1, 3/6, 3/4
3/4, 0/3, 1/1     'will be considered is duplicate with the first data

```

Is there any way to find and remove duplicate data like this.

My current method is to split into 3 strings based on "," then check with the following condition.

```
'I got each String value by mid command.
'FrstStr1: First String of String 1
'SecStr1: Second String of String 1
'ThrStr1: Third String of String 1
'FrstStr2: First String of String 2
'SecStr2: Second String of String 2
'ThrStr2: Third String of String 2

if (FrstStr1 = FrstStr2 and SecStr1 = SecStr2 and ThrStr1 = ThrStr2) or (FrstStr1 = FrstStr2 and SecStr1 = ThrStr2 and ThrStr1 = SecStr2) or () or () .... then

```

I have listed 6 possible cases and put them into if condition like above

It work but look like stupid way.

i wonder there is any better way? excel or vba whatever

Thank you for reading my question