Sorting and removing duplets

[techem]

Hi. I hope somebody can help me.

I need a macro which can do the following:

Sheet 1
C1 C2 C3
1 22 Data1
2 11 Data2
3 22 Data3
4 11 Data4
5 15 Data5
6 22 Data6

after makro ----> Sheet 2

C1 C2 C3
1 22 Data1
3 22 Data3
6 22 Data6
2 11 Data2
4 11 Data4

Which means that only duplets will be shown in sheet2. But how? :dunno

[p45cal]

We're talking duplets as in using two fields to index?
Sorting's no problem, but what's the logic behind removing '15 Data5'

[techem]

We're talking duplets as in using two fields to index?
Sorting's no problem, but what's the logic behind removing '15 Data5'

The data above is just an example. I need to filter all duplicates into another sheet.

[p45cal]

see if the attached helps, run blah and it creates a new sheet.

[techem]

see if the attached helps, run blah and it creates a new sheet.

I'm sorry, but your makro didn't work for me. But thank your very much anyway.

After several hours I finally found a solution.

1. Sort column B
2. Copy the array into another sheet
3. Add a column with autofilter with true/false on duplicates - countif(b:b;b2)>1)
4. Filter only non duplicates and delete
5. Show only duplicates