Hi
It would be nice if you tried to describe what you want to acheive in
words...

Select Column A:B, then goto Data Sort Sort by "Column A", Then by
"Column B" Ok

With the list selected, goto Data Filter Advanced filter Copy to
another location Copy to "C1:D1" Check Unique records only Ok

Regards,
Per
"edml xodus" skrev i meddelelsen ...
How about names or text instead of numbers?

A B
Mary Jackson
Lucy Henderson
Cheryl Jackson
Joline Denilson
Joline Jackson
Mary Denilson
Cheryl Henderson
Mary Jackson
Lucy George
Joline George
Favian George
Favian Max
Cheryl Henderson
Krystal Henderson
Lucy Henderson
Krystal Max
Joline Henderson
Favian Max
Mary Denilson

The result should be;

D E
Cheryl Jackson
Cheryl Henderson
Favian George
Favian Max
Joline Denilson
Joline Jackson
Joline George
Joline Henderson
Krystal Henderson
Krystal Max
Lucy Henderson
Lucy George
Mary Jackson
Mary Denilson

is it still possible??