Unique records of matching pairs

P

pmarques

Hello!
I need to filter unique records acording to two columms (10xy an
error).
I want the unique ocurrences of this pairs of columms independently o
the other columms.

I have tried with advanced filter but if the columm ID is diferent an
the pair (10xy and error) is the same, it will give me another recor
that i don't want.

I have an example attached. In yellow the result that i want.

Thank´s :

+-------------------------------------------------------------------
|Filename: tests.zip
|Download: http://www.excelforum.com/attachment.php?postid=3947
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top